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

Поиск
Список
Период
Сортировка
От Narayanan, Kannan
Тема How to select the millisecond/microsecond parts of the datetime c olumn
Дата
Msg-id E3940A45EE1CD21196100001FA444AE702B0D18F@sw720x019.visa.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "J. Roeleveld"
Дата:
Сообщение: Problem with CREATE RULE ON DELETE (PostgreSQL only executes the first expression)
Следующее
От: "Narayanan, Kannan"
Дата:
Сообщение: FW: How to select the millisecond/microsecond parts of the dateti me column