On 24/03/2008 14:35, Alain Roger wrote:
for that i use "select * from now();" and store the result into a column
table.
is there a easier way to do that ? i tried to store directly now();
result but without success.
Can you show us the full SQL statement?
You could also use CURRENT_TIMESTAMP - look at the following:
http://www.postgresql.org/docs/8.3/static/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT
HTH,
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@xxxxxx
---------------------------------------------------------------
-
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
