Now() function

From: David Siebert <david(at)eclipsecat(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Now() function
Date: 2005-06-09 22:07:18
Message-ID: 42A8BD96.4080607@eclipsecat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Windows XP SP2
Java SDK V1.4.2_08
JDBC 7.4.216.jdbc3

When I use now in an update it is giving me a very odd value in the
database. This is what PGAdminIII shows 2005-06-09 13:52:46.259715
I am not expecting the decimal seconds. I am getting an out of range
error in java when I read the column.
I am porting from a V7.1 server over to 7.4
Yes I will soon move it to 8 but I have a working 7.4 server now.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2005-06-09 22:09:18 Re: Version Control?
Previous Message Phil Endecott 2005-06-09 22:04:09 Pushing limit into subqueries of a union