Re: Compare dates. - Mailing list pgsql-general

From Alvar Freude
Subject Re: Compare dates.
Date
Msg-id 3A60E6D8.61434DC4@merz-akademie.de
Whole thread Raw
In response to Compare dates.  (Uro Gruber <uros@sir-mag.com>)
List pgsql-general
Hi,

Uro Gruber schrieb:
> How is possible to compare date from postgres to php. I'm using
> Postgres DATESTYLE EUROPEAN format. I get results from my table like
>
> Sun 14 Jan 01:21:55 2001 CET
>
> And i want to check if this date is older or newer like now.

SELECT ... FROM ... WHERE date_field < NOW();
SELECT ... FROM ... WHERE date_field > NOW();


Ciao
  Alvar

--
Alvar C.H. Freude  |  alvar.freude@merz-akademie.de

    Demo: http://www.online-demonstration.org/  |  Mach mit!
Blast-DE: http://www.assoziations-blaster.de/   |  Blast-Dich-Fit
Blast-EN: http://www.a-blast.org/               |  Blast/english

pgsql-general by date:

Previous
From: Uro Gruber
Date:
Subject: Compare dates.
Next
From: Tom Lane
Date:
Subject: Re: Need "InBetween" (not just Before and After) Trigger