Re: Need timestamp function that will change within a transaction

From: Dimitri Fontaine <dim(at)hi-media(dot)com>
To: D(dot)Dante Lorenso <dante(at)lorenso(dot)com>
Cc: Postgres-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Need timestamp function that will change within a transaction
Date: 2008-05-14 20:08:31
Message-ID: 70E3A08C-7392-46F2-BDA8-1994C5FE26DC@hi-media.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Justin 2008-05-14 20:08:54 Re: rounding problems
Previous Message Andy Anderson 2008-05-14 20:02:32 Re: rounding problems