AnsweredAssumed Answered

Get Hour from mySQL TimeStamp field

Question asked by gregcaine on Jul 8, 2011
Latest reply on Dec 21, 2011 by gregcaine

Title

Get Hour from mySQL TimeStamp field

Post

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?

Outcomes