Skip site navigation (1) Skip section navigation (2)

Difference between Postgres now() and date

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 (view raw or flat)
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


pgsql-novice by date

Next:From: Ludwig LimDate: 2002-03-19 23:26:57
Subject: No postgresql.conf in 7.0.2
Previous:From: Joshua b. JoreDate: 2002-03-19 23:05:53
Subject: Approximate string matching?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group