One more question about convirsion

Posted in 1999

Alex Antropoff — 11 Sep 1999 02:53:36 GMT — source: Informix-list mailing list archive (1991-1998)

Hi! How can I convert datetime hour to second to integer amount of seconds from 00:00 ? Also, how can i do these procedures: _hour(datetime ...), _second(datetime ...), minute_(datetime) ? -- Regards, Alex Antropoff

↪ replying to Alex Antropoff

Christian Brauer — Mon, 13 Sep 1999 13:11:53 +0200 — source: Informix-list mailing list archive (1991-1998)

Aloha, what about this one (presumed Version >= 7.30): select (to_char(ae_time, "%H") * 3600) + (to_char(ae_time, "%M") * 60) + (to_char(ae_time, "%S") ) from your_table Hth, Christian Brauer