Changes to NOW() in 7.2?

From: Hunter Hillegas <lists(at)lastonepicked(dot)com>
To: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Changes to NOW() in 7.2?
Date: 2002-03-04 21:41:26
Message-ID: B8A92A06.30A29%lists@lastonepicked.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Were there any changes to NOW() in 7.2? I see this in HISTORY:

now() returns time with millisecond precision (Thomas)

I have a query like this:

SELECT tour_dates.date, WHERE date_of_show >= NOW() ORDER BY date_of_show;

On 7.1.3, this query would include the current day as well as all dates in
the future. Since moving to 7.2, it only includes dates in the future...

I am using JDBC to access the data, if that makes any difference...

Hunter

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James Leigh 2002-03-04 21:42:24 lo_open problems
Previous Message Luciano Miguel Ferreira Rocha 2002-03-04 21:38:27 Re: libcrypt.so.2