Formatting Data/Time Criteria for an SQL Select statement - Support

Formatting Data/Time Criteria for an SQL Select statement

From Support

Jump to: navigation, search

Date/Time criteria should be formatted as follows with a single quote around the data: MM/DD/YY HH:MM:SS

Enter the time portion in military time.

Example: '3/10/2004 23:00:00'

Retrieved from "http://wiki.rjssoftware.com/wiki/index.php/Formatting_Data/Time_Criteria_for_an_SQL_Select_statement"
Personal tools