format for datetime type?

[Former Member]

When I insert data into informix DB, I tried many times but failed.

anybody knows?

[Former Member]

The reason is:

the type is datetime, but precision may be year to date or year to second.

[prateek]

There is no fix format. Could you check your DBDATE or GLS_DATE environment variables?

Regards,

Prateek

[Former Member]

Hi,

In general it shoudl be DD-MMM-YY.

if you are getting error like quotes are not accepting...then do take an attribute of Quote for Date field, and map that with an constant NO.

i hope that wil solve ur poblem.

Thanks

Hamja

Edited by: Hamja Hussain on Jul 6, 2009 3:23 PM