From: | Doug Silver <dsilver(at)quantified(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Difference between Postgres now() and date |
Date: | 2002-03-19 23:25:48 |
Message-ID: | Pine.LNX.4.21.0203191510300.19690-100000@danzig.sd.quantified.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Just something I saw and wondered about it even though I don't care too
much. I ran a cgi (perl) script comparing the now() with the system
/bin/date and they're off by 38 seconds. This is on a FreeBSD 4.4 machine
and I'm running clockspeed. Now clockspeed *does* have an issue where you
have to fix the localtime to account for leap seconds, or something like
that, so I know that's the issue. But, I'm curious as to how PostgreSQL
is determining the localtime on the machine since there's a difference
between the two.
I restarted postmaster just to make sure that wasn't the issue.
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Doug Silver
Network Manager
Quantified Systems, Inc
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From | Date | Subject | |
---|---|---|---|
Next Message | Ludwig Lim | 2002-03-19 23:26:57 | No postgresql.conf in 7.0.2 |
Previous Message | Joshua b. Jore | 2002-03-19 23:05:53 | Approximate string matching? |