Re: Getting 2002-12-18T17:32:40-05:00 (ISO 8601) from to_date()

On Thu, Dec 19, 2002 at 10:50:51AM -0500, Tom Lane wrote:
> "Peter Gibbs" <peter(at)emkel(dot)co(dot)za> writes:
> > select to_char(now()+'3 days'::interval,'YYYY-MM-DDTHH24:MI:SS');
> > to_char
> > -----------------------
> > 2002-12-22NDH24:41:58
>
> Oh, duh --- "TH" is a format modifier. That's what's confusing it
> (and today being the 19TH is what's confusing us).

# select to_char(now(),'DDth Mon YYYY');
to_char
---------------
23rd Dec 2002

> So the suggestion of ... DD"T"HH ... is the way to go.

Right, Tom read docs :-).

Please, use it in always if you want to put non-format modifier into
formatting strings.

# select to_char(now(),'"YYYY-MM-DD HH24:MI:SS =" YYYY-MM-DD HH24:MI:SS');
to_char
---------------------------------------------
YYYY-MM-DD HH24:MI:SS = 2002-12-23 10:33:40

Karel

PS. sorry of my delay in this discussion, I was out of town.

--
Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/