Theodore Petrosky <[EMAIL PROTECTED]> writes: > I am sorry, I wasn't clear... when i refered to > 01 October 2003 > I got zero results. I only got results for the October > 1 date when i refered to it as september 31....
That's a bit hard to believe. Could you show us the results of the individual to_timestamp operations ("select to_timestamp(...)")? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html