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