AnsweredAssumed Answered

Get Hour from mySQL TimeStamp field

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


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?