Re: DATETIME format again

If you have 7.3 use TO_DATE (I hope this is the right name for function) and specify the format of your input field. Alternatively you can write a simple procedure that transforms you string to a valid date format. Best Regards, Octav On Mon, Jun 07, 1999 at 03:04:35PM +0000, altpeter_rueb@my-deja.com wrote: > Hello everybody, > I'm trying to use a client with a little bit weird time format. The > format I want to use is %Y%m%d %H%M%S (ex. '19991231 235959'). Setting > GL_DATETIME in this way leads to the desired result on printing. But > trying to insert a value of '235959' into a field in the interval HOUR > TO SECOND with exact the same content of this environment variable > gives sql error -1261. > Inserting colons into the literal ('23:59:59') makes everything fine. > But my data source uses this time format above. How can I get rid of > these colons ? > The informix server that I use is 7.30.U IDS on Linux. > > Thank you all, > Herbert > > > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't. -- Octav Chiriac Phone: (373) 2 22 99 67 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com