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

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