Re: Setting Date format

Posted in 1998

jowi@my-dejanews.com — Mon, 26 Oct 1998 08:23:46 GMT — source: Informix-list mailing list archive (1991-1998)

In article <70vhdl$23u$1@mawar.singnet.com.sg>, "jh" <joshuaho@mbox3.singnet.com.sg> wrote: > of the field is in date format. Is there any way that I can unload the date > format in (DMY4/) form ?? Don't know when this was introduced, but what about: SELECT TO_CHAR(somedate, "%d/%m/%Y") FROM sometable -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own