DSU Date and Time Formats
Some database table columns store configuration data values in the date, time, or time stamp
format. This section describes how to specify the correct date, time, and time stamp formats in the
configuration data worksheet.
Note: Pay attention to the spreadsheet format categories when working
with dates and times in the spreadsheet. Some configuration data must use the date or time
format category for the data setup utility to work properly.
Date
Worksheet configuration data values that are dates may use the spreadsheet format categories of general, text, or date. The date must be in the format: MM/DD/YYYY where:- MM
- is the month
- DD
- is the day
- YYYY
- is the year
Time
Worksheet configuration data values that are times may use the spreadsheet format categories of general, text, or time. The time must be in the format: HH:MM:SS where:- HH
- is the hour
- MM
- are the minutes
- SS
- are the seconds
Time stamp
Worksheet configuration data values that are time stamps may use the spreadsheet format
categories of general or text. The time stamp must be in the format: YYYY-MM-DD HH:MM:SS.ss where:
- YYYY
- is the year
- MM
- is the month
- DD
- is the day
- HH
- is the hour
- MM
- are the minutes
- SS
- are the seconds
- ss
- are the milliseconds
The data setup utility may also store the current time stamp into a database column as it
runs. To have the DSU store the current time stamp in a database column,
specify the following configuration data for the column:
- timestamp
- stores the current time stamp
- timestamp_utc
- stores the current time stamp as UTC