Re: leading zeroes in day, month

Posted in 2003

Richard Spitz — Tue, 4 Nov 2003 11:09:17 +0100 — source: Usenet: comp.databases.informix

On Mon, 3 Nov 2003, Mitja Udovc wrote: > I would like to show day(date) and month(date) with leading zeroes. Is it > any way to do that Depending on your version of the engine (should work from 7.3 onwards): to_char(date, "%d") gives you the day, to_char(date, "%m") gives you the month, both with leading zeroes. HTH, Richard