Thread: 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