Re: date functions

Posted in 1999

Octav Chiriac — Sat, 17 Apr 1999 11:05:27 +0300 — source: Informix-list mailing list archive (1991-1998)

The correct format is: to_date('19980607','%Y%m%d') Best Regards, Octav On Thu, Apr 15, 1999 at 01:53:26PM +0200, Aurelio wrote: > > Why this expression doesn't work? > > to_date('19980607','yyyymmdd') > > [Informix][Dynamic Server][dbname] SQL Error (-1277) : Input does not > match format specification. > > Thanks in advance > -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com

Related threads

RE: ontape -r on remote tape drive permission error