Re: MORE ON DATE/TIME

Posted in 1999

Obnoxio The Clown — Thu, 22 Apr 1999 07:14:16 GMT — source: Informix-list mailing list archive (1991-1998)

From: Octav Chiriac <com@netinfo-moldova.com> > >Well, it's simple (really simple) in IDS 7.3: > >select TO_CHAR(CURRENT, "%H%M%S") from systables [SNIP] Because On Thu, Apr 22, 1999 at 06:30:34AM +0000, Obnoxio The Clown wrote: >> From: Aurelio <i52sacaa@uco.es> >> >> >I still have problems with date/time: >> > >> >How can I do this? >> >define currentTime CHAR(8); >> >let currentTime = to_char(CURRENT,[format for having hhhhmmss]); I said: >> IDS also has a TOCHAR function for handling dates, but the manual is a >> little fuzzy, if anyone has used it and can give an example, I'd also >> be interested. I then put my foot in it, saying: >> Aurelio, I might also note that *all* of this was taken out of TFM. >> You may want to R it at some stage... :-) Pot. Kettle. Black. :-) Thanks, Octav! ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com