In response to "Kurt Westerfeld" <kwesterfeld@xxxxxxxxxx>: > >>> RadosÅaw Smogura<rsmogura@xxxxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
