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

Karl DeBisschop wrote:

> I'd like to get an ISO 8601 date from postgresql in the following form:
>
> 2002-12-18T17:26:04-05:00
>
> Second is the 'T' after the date part (where you might otherwise have a
> space).

Quote from the docs:
Ordinary text is allowed in to_char templates and will be output literally.
You can put a substring in double quotes to force it to be interpreted as
literal text even if it contains pattern keywords. For example, in '"Hello
Year: "YYYY', the YYYY will be replaced by year data, but the single Y will
not be.

So, try
# select to_char(now(),'YYYY-MM-DD"T"HH24:MI:SS');

--
Peter Gibbs
EmKel Systems