Re: Date to Time conversion

There is a DATE() function in SQL that will convert a properly-formatted CHAR into a date variable. For your needs, you'll probably want to work with DATETIME and INTERVAL, not just DATE, which also has EXTEND() functions that will help. Be aware that the format of the string is pretty strict. The SQL and 4GL manuals have some details. (Hmmm ... a lot of DATE and DATETIME questions are coming up. I wonder if Y2K has anything to do with it ...) In article <706o9g$evs$1@news.xmission.com>, Anil Khanna <anilk@india.infogain.com> wrote: > > HI, > Is there any built-in function available in informix to convert > CHAR into a DATE? > I have columns start_trx_time and end_trx_time in a table which are > defined as chars, but ,I want to get the differencesof the two time for > some purpose. > Can anyone help me ? > > Thanks in advance > > -- Dennis J Pimple Informix Software, Inc. Denver, CO, USA Y2K compliant since 1955! -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own