-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-CU
On May 14, 2008, at 12:56 PM, D. Dante Lorenso wrote:
I'd like to find a timestamp function that WILL change within a
transaction.
This function will return to me a 15 digit BIGINT number in base10:
SELECT FLOOR(EXTRACT(EPOCH FROM NOW()) * 10)::bigint;
The problem is that NOW() does n