In response to "Kurt Westerfeld" <[email protected]>: > >>> Radosław Smogura<[email protected]> 1/4/2011 9:48 AM >>> > Can You try "...BETWEEN ?::date and ?::date ..." syntax or send > statement causing problems? > > As for the BETWEEN clause, I'm using hibernate and don't want to put a > database-specific SQL query in place.
You could do "BEWTEEN CAST(? AS DATE) AND CAST(? AS DATE)" and it wouldn't be database-specific. You might also want to consider top-posting. I'm not sure why I read enough of this to understand it, as I usually get confused an frustrated when things have been top posted and stop reading. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
