Analyst Tool Guide

Back Next

Datetime Data Types

When you configure the datetime data type, you can specify the format in the

Datetime Format

window. You can use the default or specify another datetime format and choose to make this the default datetime format.

You can specify the following datetime format strings as part of the date:

AM, a.m., PM, p.m.: Meridian indicator. Use any of these format strings to specify AM and PM hours. AM and PM return the same values as a.m. and p.m.
DAY: Name of day, including up to nine characters. The DAY format string is not case sensitive.
DD: Day of month.
DDD: Day of year including leap years.
DY: Abbreviated three-character name for a day. The DY format string is not case sensitive.
HH, HH12: Hour of the day.
HH24: Hour of the day from 0-23, where 0 is 12AM.
J: Modified Julian Day.
MI: Minutes from 0-59.
MM: Month
MONTH: Name of month, including up to nine characters. Case does not matter.
MON: Abbreviated three-character name for a month. Case does not matter.
MS: Milliseconds from 0-999.
NS: Nanoseconds from 0-999999999.
RR: Four-digit year. Use when source strings include two-digit years.
SS: Seconds from 0-59.
SSSSS: Seconds since midnight.
US: Microseconds from 0-999999.
Y: The current year with the last digit of the year replaced with the string value.
YY: The current year with the last two digits of the year replaced with the string value.
YYY: The current year with the last three digits of the year replaced with the string value.
YYYY: Four digits of a year. Do not use this format string if you are passing two-digit years. Use the RR or YY format string instead.