extending Now() information

On Thu, 2002-06-13 at 14:37, Vilson farias wrote:

Greetings,

I was wondering how could Now() procedure shows the timestamp with miliseconds information. Is it possible?

select now();
Result : 2002-06-13 19:33:23.35+00 instead of 2002-06-13 19:33:23+00.

It's there:
$ psql
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

ler=# select now();
now
-------------------------------
2002-06-13 15:00:25.420657-05
(1 row)

ler=# select version();
version
---------------------------------------------------------------------
PostgreSQL 7.2.1 on i386-portbld-freebsd4.6, compiled by GCC 2.95.3
(1 row)

ler=#

Thanks in advance.

--------------------------------------------------------------------------------
José Vilson de Mello de Farias
Analista de Sistemas

Dígitro Tecnologia Ltda - www.digitro.com.br
APC - Aplicativos Orientados ao Cliente
E-mail: vilson.farias@digitro.com.br
Tel.: +55 48 281 7158
ICQ 11866179

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

"Vilson farias" <vilson.farias@digitro.com.br> writes:

I was wondering how could Now() procedure shows the timestamp with milise=
conds information. Is it possible?

Try updating to 7.2.

regards, tom lane