Standard Date and Time Transforms

The following list includes all of the standard date and time formats supported by Relativity. All of these transforms will return an SQL Date, SQL Time, or SQL Date/Time value. The following transforms may be modified using transform modifiers.

Note: For information on the date and time transform modifiers, see Modifiers for Date and Time Transforms.
HHMM YYYYDDDHHMM MMDDYYYYHHMM
HHMMSS YYYYDDDHHMMSS MMDDYYYYHHMMSS
HHMMSShh YYYYDDDHHMMSShh MMDDYYYYHHMMSShh
YYDDD YYYYMMDD DDMMYY
YYDDDHHMM YYYYMMDDHHMM DDMMYYHHMM
YYDDDHHMMSS YYYYMMDDHHMMSS DDMMYYHHMMSS
YYDDDHHMMSShh YYYYMMDDHHMMSShh DDMMYYHHMMSShh
YYMMDD MMDDYY DDMMYYYY
YYMMDDHHMM MMDDYYHHMM DDMMYYYYHHMM
YYMMDDHHMMSS MMDDYYHHMMSS DDMMYYYYHHMMSS
YYMMDDHHMMSShh MMDDYYHHMMSShh YYYYDDD
MMDDYYYY DDMMYYYYHHMMSShh
Parent topic: Transforms