On Sun, 2005-02-13 at 18:57 +0200, raptor wrote:
> how to compare dates with timestamp..if i dont care about
> the hour:minute part of the timestamp... i.e. i want
> to be able to do exact match :
>
> timestamp in (select date from table where .)
Try something like this: (created is a timest
On Sun, 13 Feb 2005 18:57:30 +0200, raptor <[EMAIL PROTECTED]> wrote:
> how to compare dates with timestamp..if i dont care about
> the hour:minute part of the timestamp... i.e. i want
> to be able to do exact match :
>
> timestamp in (select date from table where .)
timestamp::DATE in ((sele
how to compare dates with timestamp..if i dont care about
the hour:minute part of the timestamp... i.e. i want
to be able to do exact match :
timestamp in (select date from table where .)
tia
---(end of broadcast)---
TIP 5: Have you checked
My date setting is ISO with US conventions, and output from a select
is in the form -mm-dd (2002-01-18, for example.
When I do a select such as
SELECT * FROM table WHERE date BETWEEN '2001-12-28' AND '2002-01-28'
It misses the entry with date '2002-01-28' (which does exist!).
Likewise,
S
7;days', 'now'::timestamp - '10 Sep
2000'::timestamp);
date_part
---
75
(1 row)
Hope this helps.
Regards
Francis
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Ellen Spertus
> Sent: 17 November 200
After upgrading from 6.x to 7.x, the following query broke, I lost the
ability to check how many days apart two DATEs are by subtracting
them. What is the correct way to determine the difference between two
dates in 7.x?
Thank you.
Ellen Spertus
