Re: Need timestamp function that will change within a transaction

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: Need timestamp function that will change within a transaction
Дата
Msg-id 70E3A08C-7392-46F2-BDA8-1994C5FE26DC@hi-media.com
обсуждение исходный текст
Ответ на Need timestamp function that will change within a transaction  ("D. Dante Lorenso" <dante@lorenso.com>)
Ответы convert very large unsigned numbers to base62?
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Le 14 mai 08 à 21:56, D. Dante Lorenso a écrit :

> I'd like to find a timestamp function that WILL change within a
> transaction.

See the fine manual:
   http://www.postgresql.org/docs/current/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

It saith that timeofday() and clock_timestamp() are what you're after.
Most likely it's clock_timestamp().

Regards,
- --
dim
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (Darwin)

iEYEARECAAYFAkgrRr8ACgkQlBXRlnbh1bmrjgCgqjOiIkQ+EvZi262FYYzRjol1
V9QAoIoj9wYb01K8e939F/LkZ2fDjVpg
=rI75
-----END PGP SIGNATURE-----

В списке pgsql-general по дате отправления:

Предыдущее
От: Andy Anderson
Дата:
Сообщение: Re: rounding problems
Следующее
От: Justin
Дата:
Сообщение: Re: rounding problems