Get Hour from mySQL TimeStamp field
I have an ODBC connection from FileMaker Pro Advanced 11 to a table in mysQL 5.1 that has a timestamp field. From FileMaker, the time in the timestamp field displays 12:00:00. AN ODBC connection from ACCESS 2007 correctly displays the timestamp.
I need to create a calculated field for records created after 11:00PM. Using the HOUR function and other attempts have been unsuccessful.
Can someone suggest a way to capture the timestamp so I can parse by the hour?