Re: JDBC timestamp escape format

Posted in 1998

Thomas J. Girsch — Thu, 5 Nov 1998 11:55:18 -0500 — source: Informix-list mailing list archive (1991-1998)

You actually have to specify all the way down to FRACTION(5) or it won't work. As in: {ts 1999-12-31 00:00:00.00000} Svetlin Manavski wrote in message <36418EE6.BA391539@csinternational.it>... >Hi, >what is the JDBC timestamp escape format of the Informix drivers? >The standard one does not work: > >{ts 1999-12-31 00:00:00} > >my column is of DATETIME YEAR TO FRACTION(5) type >and I get the SQLException: > >ERROR: Error in timestamp format "1999-12-31 00:00:00" > >I have tried many variations of this format but no way to make it work. >Svetlin > > >