FW: How to select the millisecond/microsecond parts of the dateti me column - Mailing list pgsql-general

From Narayanan, Kannan
Subject FW: How to select the millisecond/microsecond parts of the dateti me column
Date
Msg-id E3940A45EE1CD21196100001FA444AE702B0D191@sw720x019.visa.com
Whole thread Raw
List pgsql-general
> Hello,
>
> Product version: Postgres 6.5.3
>
> SELECT DATETIME('MILLISECOND', 'NOW'::DATETIME) always returns 0(ZERO) and
> so does 'MICROSECOND'. However a reading of the manuals indicate that the
> database supports much higher precision values. How do I retrieve the
> additional precision values (beyond seconds) when I use the datetime
> field? This is a requirement for a conversion project that I am working
> on. Could someone help please.
>
> Thanks
> Kannan
>

pgsql-general by date:

Previous
From: "Narayanan, Kannan"
Date:
Subject: How to select the millisecond/microsecond parts of the datetime c olumn
Next
From: Mark Kirkwood
Date:
Subject: Slow Sort and Group By for Star Query