thanks... as is so often the case I discovered
date_trunc('day', insertdate) between '11/20/2005' AND
'11/20/2005' also works
It wasn't until I pressed the send button that I
thought of the solution. I have thought of creating a
faux 'send' button for my email software... yours is a
little e
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
