Oninit cdi / Archive
Talk to an expert →

Re: system date/time

Posted in 2004

Topics: General Discussion

kstahl — — source: Usenet: comp.databases.informix

Jonathan Leffler wrote: > Jonathan Leffler wrote: > [...] > >> If you want time as well as date, then: >> >> SELECT CURENT FROM Dual;> > > Oops - typo: CURRENT -- optionally qualified by something like YEAR TO > FRACTION(3), or MONTH TO MINUTE, or ... > Ok, thanks. That just what I needed. I don't work with Informix very often (mostly Oracle and MSSQL), but occasionally I have to delve in and I don't have much documentation available to me.

↪ replying to kstahl
June C. Hunt — — source: Usenet: comp.databases.informix

kstahl wrote: > Jonathan Leffler wrote: > > Jonathan Leffler wrote: > > [...] > > > >> If you want time as well as date, then: > >> > >> SELECT CURENT FROM Dual;> > > > > > Oops - typo: CURRENT -- optionally qualified by something like YEAR TO > > FRACTION(3), or MONTH TO MINUTE, or ... > > > > Ok, thanks. That just what I needed. I don't work with Informix > very often (mostly Oracle and MSSQL), but occasionally I have to > delve in and I don't have much documentation available to me. I tried to respond to you directly but there was an e-mail delivery failure so I'm posting this here. The following link will get you to the on-line IBM Informix documentation. http://www-306.ibm.com/software/data/informix/pubs/library/lists.html -- June Hunt

Related threads