Informix database issue: Changing the datatype format

Question

I am using informix database for storing the data. Everything is storing correctly. But I need to change the datatype format of the Timecol. Now the TimeCol format is yyyy-mm-dd hh:mm:ss:0000. While storing the data,the Timecol is coming like that. I want to change the 0000 from the Timecol. Is it possible to change the datatype format of Timecol in informix database?

Answer 1

it seems that you cannot change it but adjust it with extend.

for example

select extend(current,year to fraction(2)) from sysmaster:sysdual