On Sat, Dec 03, 2005 at 09:54:16AM -0800, Theodore Petrosky wrote:
> if 'between' is inclusive of the start and end dates why doesn't
> this query result in all the rows on '11/20/2005'?
EXPLAIN shows what happens when you compare a date against a timestamp:
Filter: ((insertdate >= '2005-11-20 00
My table
create table mytable (
employeecode text,
info text,
somestuff text,
insertdate timestamp with time zone);
I have an interface where the user can query for all
employeecode between two dates. I assumed from the
docs that:
SELECT employeecode FROM mytable WHERE insertdate
BETWEEN '11/20/
Tom,
I found the problem. It seems that a function I was calling
date_add_days(date,int)
Returned for some reason a text date + [some unprintable garbage] two
characters worth
This in turn caused the quote_literal() to fail by returning only the
initial single quote.
I resolved the problem by rep
