Hello:
I´m new to postgresql and moving from access. Right ow I have a big project that rely heavely on date/time filters. in access the queries would look something like:
SELECT * FROM people WHERE timein > #3/1/2002 12:58#
This statement selects all the records where "timein" is greater than March 1 of 2002 and 12 hours 58 minutes AM.
The problem I have is how do I translate this kind of statement into SQL that postgresql understand while I retain compatibility with access.
I´m willing to change the code, but I need something that will work in Postgresql and access
I alsop read on the mailing list that I should use ISO dates (yyyy/mm/dd hh:mm:ss) This is no problem.
Thanks too anyone who can help
Hernán Breinbauer