DateTime Formats

Some of the functions used in the library allow for a specified date & time format as either required by a function or in some cases as desired as an output.

The following are constants defined in the DateTime.inc include file.

DateTime Constant	Example of DateTime String
CCYYMMDDHHMMSSMS	1974/03/27 14:53:01:00
CCYYMMDDHHMMSS	1974/03/27 14:53:01
CCYYMMDDHHMM	1974/03/27 14:53
CCYYMMDD	1974/03/27
CCYYMM	1974/03
YEAR	1974
DDMMCCYYHHMMSSMS	27/03/1974 14:53:01:00
DDMMCCYYHHMMSS	27/03/1974 14:53:01
DDMMCCYYHHMM	27/03/1974 14:53
DDMMCCYY	27/03/1974
DDMM	27/03
DAY	27
MMDDCCYYHHMMSSMS	03/27/1974 14:53:01:00
MMDDCCYYHHMMSS	03/27/1974 14:53:01
MMDDCCYYHHMM	03/27/1974 14:53
MMDDCCYY	03/27/1974
MMDD	03/27
MONTH	03
YYMMDDHHMMSSMS	74/03/27 14:53:01:00
YYMMDDHHMMSS	74/03/27 14:53:01
YYMMDDHHMM	74/03/27 14:53
YYMMDD	74/03/27
YYMM	74/03
YY	74
MMDDYY	03/27/74
DDMMYY	27/03/74
DAYOFWEEK	Monday
HHMMSSMS	14:53:01
HHMMSS	14:53:01
HHMM	14:53
HH	14
UNIXTIMESTAMP	1276278420
TODAY	same as DDMMCCYYHHMMSS
NOW	same as DDMMCCYYHHMMSS
TIME	same as HHMM
AMERICAN	same as MMDDYY
BRITISH	same as DDMMYY
FRENCH	same as DDMMYY
JAPAN	same as YYMMDD
TAIWAN	same as YYMMDD
MDY	same as MMDDYY
DMY	same as DDMMYY
YMD	same as YYMMDD

Note

Constants: CC=Century, YY=Year, MM=Month, DD=Day, HH=Hours, MM=Minutes, SS=Seconds, MS=Milliseconds, DOW=Day Of Week

Note

The UNIXTIMESTAMP format is a string representation of the unix time in integer format and used in the DTDateTimeStringToUnixTime and DTUnixTimeToDateTimeString functions.