How to select the millisecond/microsecond parts of the datetime c olumn

From: "Narayanan, Kannan" <knarayan(at)visa(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: How to select the millisecond/microsecond parts of the datetime c olumn
Date: 1999-11-17 20:29:42
Message-ID: E3940A45EE1CD21196100001FA444AE702B0D18F@sw720x019.visa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Narayanan, Kannan 1999-11-17 20:40:40 FW: How to select the millisecond/microsecond parts of the dateti me column
Previous Message J. Roeleveld 1999-11-17 20:21:52 Problem with CREATE RULE <something> ON DELETE (PostgreSQL only executes the first expression)