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