Service Studio 6.0 Help
Date Time Data Type
The Date Time data type stores an instant of time expressed as a date and time of day. A Date Time literal must be enclosed with number signs (#) and in the format YYYY-MM-DD hh:mm:ss. The supported range of this data type goes from 1900-01-01 00:00:00 to 3000-12-31 23:59:59.
Time AM/PM format is not a supported format to be used in the Date Time literal
The Date Time data type manages the date and time components as a whole, but you can extract the date and time through the built-in functions.
Built-in Date & Time Functions | Formatting Functions | About Null Values | About Date Time Literal | Available Data Types