[rajeshwar_rao]

Hey can any one tell the equivalant of to_date of oracle. my problem is i am trying to insert data in dd/mm/yyyy format but the informix default format is set to mm/dd/yyyy


the insert statement is as follows

insert into testingdate values(to_date('20/03/2004', '%d/%m/%y'));

but some how this works

select to_char(datetest, '%d/%m/%y') from testingdate;

and returns me date in dd/mm/yy ...

[pprince]

Originally posted by rajeshwar_rao
Hey can any one tell the equivalant of to_date of oracle. my problem is i am trying to insert data in dd/mm/yyyy format but the informix default format is set to mm/dd/yyyy


the insert statement is as follows

insert into testingdate values(to_date('20/03/2004', '%d/%m/%y'));

but some how this works

select to_char(datetest, '%d/%m/%y') from testingdate;

and returns me date in dd/mm/yy ...

Try a capital Y

[rajeshwar_rao]

Hi thanq for the suggestion its not Y but its 'iy'

[pprince]

Originally posted by rajeshwar_rao
Hi thanq for the suggestion its not Y but its 'iy'

Oh Yeah!

Have just double checked the documentation!

[rajeshwar_rao]

In fact i cheked it and also tried it over the database it works that way

Thanks and regards