Обсуждение: using between with dates

Поиск
Список
Период
Сортировка

using between with dates

От
Geoffrey Myers
Дата:
I'm trying the following:

ship_date between '04/30/2010' AND '04/30/2010' + 14

But this returns:

ERROR:  invalid input syntax for integer: "04/30/2010"

Can I use between with dates?

--
Geoffrey Myers
Myers Consulting Inc.
770.592.1651

Re: using between with dates

От
Szymon Guz
Дата:


2010/4/29 Geoffrey Myers <geof@serioustechnology.com>
I'm trying the following:

ship_date between '04/30/2010' AND '04/30/2010' + 14

But this returns:

ERROR:  invalid input syntax for integer: "04/30/2010"

Can I use between with dates?



This should be fine:
ship_date between '04/30/2010'::date AND '04/30/2010'::date + 14

regards
Szymon Guz
 

Re: using between with dates

От
Thom Brown
Дата:
On 29 April 2010 14:55, Geoffrey Myers <geof@serioustechnology.com> wrote:
I'm trying the following:

ship_date between '04/30/2010' AND '04/30/2010' + 14

But this returns:

ERROR:  invalid input syntax for integer: "04/30/2010"

Can I use between with dates?


You need to cast that last date, so:

ship_date between '04/30/2010' AND '04/30/2010'::date + 14

Thom

Re: using between with dates

От
"A. Kretschmer"
Дата:
In response to Geoffrey Myers :
> I'm trying the following:
>
> ship_date between '04/30/2010' AND '04/30/2010' + 14
>
> But this returns:
>
> ERROR:  invalid input syntax for integer: "04/30/2010"
>
> Can I use between with dates?

Sure, why not, but you have to CAST your STRING into a DATE, or you have
to use to_date().

test=*# select '04/30/2010'::date;
    date
------------
 2010-04-30
(1 row)


And yes, write "+ '14 days'::interval " instead of just only +14.


Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99