Re: [pgsql-general] Daily Digest V1 #2891 - Mailing list pgsql-general

Karl DeBisschop <kdebisschop@alert.infoplease.com> writes:
> I could do
> | news=> set datestyle TO 'ISO';
> | SET VARIABLE
> | news=> select now();
> |               now
> | -------------------------------
> |  2002-12-19 11:27:40.145603-05
> | (1 row)

> But that has spaces instead of the 'T'

In 7.3, this works:

regression=# set datestyle TO 'ISO';
SET
regression=# select replace(current_timestamp(2)::text, ' ', 'T');
          replace
---------------------------
 2002-12-19T11:46:15.91-05
(1 row)


            regards, tom lane