Richard Huxton writes:
> The time is fixed at the start of the transaction. This lets you do
> several inserts having the same timestamp.
I think there's another problem here, which is that he's declared
"currenttime" as a timestamp without time zone, but the
CURRENT_TIMESTAMP function yields tim
[EMAIL PROTECTED] wrote:
> For example, the machine time is 11:46:xx, and I execute the SQL insert
> through the jdbc, the record time will be changed to 10:52:xx. I mean the
> time value is always slower than the machine time but not for a fixed time
> period.
>
> My java appserver is Sun Jav
Hi, all
I get a problem with the jdbc and timestamp data column.
My postgresql running on the Solaris 10 and version is 8.1.6.
The table looks like this,
create DOMAIN CURRENTTIME AS TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
create table RY_ArticleCollection (
ArtIDINT4