On Thu, Mar 01, 2001 at 05:33:21PM +0100, Paolo Sinigaglia wrote: > > >Can anybody show any reason why the code using a prepared > > statement with a where clause using a date won't find any records > > on PostgreSQL but WILL work using Access and the jdbc-odbc > > bridge? > > > Assuming you are running PostgreSQL on a *nix machine and the odbc client on > a Win* different machine, couldn't be a problem of different locale > settings? > > Using Delphi BDE I had **a lot** of troubles on an all-windows-98 network > because of different locale settings among the clients. First in all, > day-month swapping in dates (dd-mm-yyyy and mm-dd-yyyy formats mixed through > the network). Make all dates ISO format and life should be good. I think MS Access does something like that for ODBC. So, yyyy-mm-dd ('2001-03-01') or dd-MMM-yyyy ('01-Mar-2001'), are good candidates. For time as well: yyyy-mm-dd hh:mm[:ss[-hh[mm]]] '2001-03-01 23:42:58-0800' Always having year first makes a good heuristic that date/time is in ISO format, and there's no question that each successive part represents a decreasing date/time part. -- Eric G. Miller <[EMAIL PROTECTED]>