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