Creating Datetime Values

MakeDateTZ

MakeDateTZ(<year>, <month>, <day>, TZ)

Creates a DateTime value where the parameters passed in are expressed in the TZ timezone.

If there is an error making the date, the default DateTime of "Jan 1, 1970 12:00:00 AM" server local time is created.

MakeDateUTC

MakeDateUTC(<year>, <month>, <day>)

Makes a datetime value. The parameters passed in are assumed to be in universal coordinated time.

If there is an error making the date, the default DateTime of "Jan 1, 1970 12:00:00 AM" server local time is created.

MakeDateTimeTZ

MakeDateTimeTZ(<year>, <month>, <day>, <hour>, <minute>, <second>, TZ )

Creates a DateTime value where the parameters passed in are expressed in in the TZ timezone.

If there is an error making the date, the default DateTime of "Jan 1, 1970 12:00:00 AM" server local time is created.

MakeDateTimeUTC

MakeDateTimeUTC(<year>, <month>, <day>, <hour>, <minute>, <second> )

Makes a datetime value. The parameters passed in are assumed to be in universal coordinated time

If there is an error making the date, the default DateTime of "Jan 1, 1970 12:00:00 AM" server local time is created.

ToDT

toDT ( String )

Creates a datetime from a string. The string will have one of the following formats:

YYYYMMDDHHmmSSZ 

YYYYMMDDHHmmSS 

YYYYMMDDHHmmZ 

YYYYMMDDHHmm 

YYYYMMDDZ 

YYYYMMDD  

where

YYYY = Year 

MM = Month 

DD = Day 

HH = Hour 

mm = Minute 

SS = Second 

Z = Indicates that this is a UTC datetime. 

If there is an error making the date, the default DateTime of "Jan 1, 1970 12:00:00 AM" server local time is created.

ToDTTZ

toDTTZ ( String, TZ )

Creates a datetime from the string where the string is expressed . The string will have one of the the formats:

YYYYMMDDHHMMSSZ
YYYYMMDDHHMMSS 
YYYYMMDDHHMMZ 
YYYYMMDDHHMM 
YYYYMMDDZ 
YYYYMMDD 

where

YYYY = Year 

MM = Month 

DD = Day 

HH = Hour 

MM = Minute 

SS = Second 

Z = Indicates that this is a UTC datetime. If you specify Z at the end of the string for toDTTZ, the timezone is not used. 

 

If there is an error making the date, the default DateTime of "Jan 1, 1970 12:00:00 AM" server local time is created.