Обсуждение: extending Now() information
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.
Result : 2002-06-13 19:33:23.35+00 instead of 2002-06-13 19:33:23+00.
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
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
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