Re: extending Now() information
От | Larry Rosenman |
---|---|
Тема | Re: extending Now() information |
Дата | |
Msg-id | 1023998470.371.51.camel@lerlaptop обсуждение исходный текст |
Ответ на | extending Now() information ("Vilson farias" <vilson.farias@digitro.com.br>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: