Selecting and Formating Dates – Informix Archive

efelito@hotmail.com — Fri, 11 Aug 2000 17:32:18 GMT — source: Informix-list mailing list archive (1991-1998)

I need to know the syntax for selecting and formating dates in Informix. In SQL Server if I run this "Select convert(varchar(10), getdate(), 12)" I get this "000811" I need something comprable in Informix. Thanks. Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to efelito@hotmail.com

Art S. Kagel — Tue, 15 Aug 2000 10:02:36 -0400 — source: Informix-list mailing list archive (1991-1998)

If you select: SELECT YEAR(today)||MONTH(today)||DAY(today) FROM systables WHERE tabid = 1; Art S. Kagel efelito@hotmail.com wrote: > > I need to know the syntax for selecting and formating dates in > Informix. In SQL Server if I run this "Select convert(varchar(10), > getdate(), 12)" I get this "000811" I need something comprable in > Informix. Thanks. > > Sent via Deja.com http://www.deja.com/ > Before you buy.

↪ replying to efelito@hotmail.com

Art S. Kagel — Tue, 15 Aug 2000 10:16:04 -0400 — source: Informix-list mailing list archive (1991-1998)

If you select: SELECT YEAR(today)||MONTH(today)||DAY(today) FROM systables WHERE tabid = 1; Art S. Kagel efelito@hotmail.com wrote: > > I need to know the syntax for selecting and formating dates in > Informix. In SQL Server if I run this "Select convert(varchar(10), > getdate(), 12)" I get this "000811" I need something comprable in > Informix. Thanks. > > Sent via Deja.com http://www.deja.com/ > Before you buy.