Re: Comparing Dates

From: Ian Barwick <barwick(at)gmail(dot)com>
To: Nick Peters <nick(dot)peters(at)candoltd(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Comparing Dates
Date: 2004-11-18 21:10:23
Message-ID: 1d581afe04111813105e42b319@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, 18 Nov 2004 15:01:58 -0600, Nick Peters
<nick(dot)peters(at)candoltd(dot)com> wrote:
> Hey,
>
> I am trying to compare dates in a sql statement. this is what i have tried:
>
> SELECT * FROM transactions WHERE shippingdate>2004-06-08 AND
> transtype='Sale';

SELECT * FROM transactions WHERE shippingdate> '2004-06-08' AND
transtype='Sale';

Ian Barwick

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas F.O'Connell 2004-11-18 21:15:30 Re: Comparing Dates
Previous Message Nick Peters 2004-11-18 21:01:58 Comparing Dates