Postgres Pro
Downloads
Home   >   mailing lists

How to select the millisecond/microsecond parts of the datetime c olumn - Mailing list pgsql-general

From Narayanan, Kannan
Subject How to select the millisecond/microsecond parts of the datetime c olumn
Date
Msg-id E3940A45EE1CD21196100001FA444AE702B0D18F@sw720x019.visa.com
Whole thread Raw
List pgsql-general
Tree view 
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: "J. Roeleveld"
Date:
Subject: Problem with CREATE RULE ON DELETE (PostgreSQL only executes the first expression)
Next
From: "Narayanan, Kannan"
Date:
Subject: FW: How to select the millisecond/microsecond parts of the dateti me column