Unanswered: Datetime field results from prior to specific date and time
Please forgive my total lack of DB2 information. I'm actually trying to write a pass-through query in MS Access, but the back end DB server is DB2, so that's why I'm asking here. I have no clue about hardware or version of DB2, but I hope that the basic generality of my question doesn't require that information. I'll say up front that my database experience has been primarily limited to using the Query-by-example grid in MS Access, but I do have some basic understanding of SQL. I think what I'm looking for is the proper SQL syntax for DB2 to return the results I'm seeking.
Basically I have a table that has a datetime field, and I want to query records that have datetimes earlier than a specific date AND time. I've seen plenty of SQL examples on looking for records prior to a date, but I need to narrow it down to a time, too. Here's my SQL:
WHERE LOGDT < #5/1/2009 9:00:00 AM# ;
I'm getting the following error with this:
SQL0104N An unexpected token "9" was found following "RE LOGDT > #5/1/2009".
To me this is saying that there's an issue with using the bangs to delimit the date and time information. I also tried single quotes and get this error instead:
SQL0180N The syntax of the string representation of a datetime value is incorrect.
So, can someone point me in the right direction for this? I tried various general SQL tutorials and such thinking that I may find the answer there as a basic SQL mistake, but a lot of what I'm gleaning from those is "don't put your dates and times in the same field, so here's an example for querying dates only..." Unfortunately I don't have the luxury of choosing as this is the database that's running our warehouse and it's already setup this way.
Thanks ahead of time for helping out this SQL/DB2 beginner...