Geoffrey 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?
Got it:
ship_date between '04/30/2010' and timestamp '04/30/2010' + interval '14
day'
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
