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

From: "Peter Gibbs" <peter(at)emkel(dot)co(dot)za>
To: "Karl DeBisschop" <kdebisschop(at)alert(dot)infoplease(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>, "Karel Zak" <zakkr(at)zf(dot)jcu(dot)cz>
Subject: Re: Getting 2002-12-18T17:32:40-05:00 (ISO 8601) from to_date()
Date: 2002-12-19 15:45:16
Message-ID: 04ac01c2a775$a0bdca00$0b01010a@emkel.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:

> regression=# select to_char(now(),'YYYY-MM-DDTHH24:MI:SS');
> to_char
> -----------------------
> 2002-12-19THH24:32:10
> (1 row)
>
> If the first two both work, I don't see why the third case shouldn't ...

Try:
select to_char(now()+'3 days'::interval,'YYYY-MM-DDTHH24:MI:SS');
to_char
-----------------------
2002-12-22NDH24:41:58
(1 row)

--
Peter Gibbs
EmKel Systems

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-12-19 15:50:51 Re: Getting 2002-12-18T17:32:40-05:00 (ISO 8601) from to_date()
Previous Message Tom Lane 2002-12-19 15:33:57 Re: Getting 2002-12-18T17:32:40-05:00 (ISO 8601) from to_date()