extending Now() information

From: "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: extending Now() information
Date: 2002-06-13 19:37:53
Message-ID: 004401c21311$d0232090$98a0a8c0@dgtac
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

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(dot)farias(at)digitro(dot)com(dot)br
Tel.: +55 48 281 7158
ICQ 11866179

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip Hallstrom 2002-06-13 19:42:53 Re: read this and puke
Previous Message Bruce Momjian 2002-06-13 19:22:59 Re: read this and puke