ai.date

Supported Timezones

Supported Date Format String Tokens

Year, Month, and Day Tokens

Input	Example	Description
YYYY	2014	4 or 2 digit year
YY	14	2 digit year
Q	1..4	Quarter of year. Sets month to first month in quarter.
M MM	1..12	Month number
MMM MMMM	Jan..December	Month name in locale
D DD	1..31	Day of month
Do	1st..31st	Day of month with ordinal
DDD DDDD	1..365	Day of year
X	1410715640.579	Unix timestamp
x	1410715640579	Unix ms timestamp

YYYY from version 2.10.5 supports 2 digit years, and converts them to a year near 2000 (same as YY).

Week Year, Week, and Weekday Tokens

For these, the lowercase tokens use the locale aware week start days, and the uppercase tokens use the ISO week date start days.

Input	Example	Description
gggg	2014	Locale 4 digit week year
gg	14	Locale 2 digit week year
w ww	1..53	Locale week of year
e	1..7	Locale day of week
ddd dddd	Mon...Sunday	Day name in locale
GGGG	2014	ISO 4 digit week year
GG	14	ISO 2 digit week year
W WW	1..53	ISO week of year
E	1..7	ISO day of week

Hour, Minute, Second, Millisecond, and Offset Tokens

Input	Example	Description
H HH	0..23	24 hour time
h hh	1..12	12 hour time used with a A.
a A	am pm	Post or ante meridiem
m mm	0..59	Minutes
s ss	0..59	Seconds
S SS SSS	0..999	Fractional seconds
Z ZZ	+12:00	Offset from UTC as +-HH:mm, +-HHmm, or Z

Creating ISO8601 Datetime Strings

// create a date from a date fragment that is in ISO8601 format
var date = ai.date.create('2016-02-01', 'America/Los_Angeles');
// date is "2016-02-01T00:00:00-08:00"
 
// create a date from a date fragment that is NOT in ISO8601 format
var date = ai.date.create('02/01/2016', 'America/Los_Angeles', 'MM/DD/YYYY');
// date is "2016-02-01T00:00:00-08:00"
 
// create a date from a date fragment that is NOT in ISO8601 format, but in Australian format
var date = ai.date.create('02/01/2016', 'America/Los_Angeles', 'DD/MM/YYYY');
// date is "2016-01-02T00:00:00-08:00"
 
// create a date from a date and time fragment, but no offset, fragment is in ISO8601 format.
var date = ai.date.create('2016-02-01T05:00', 'America/Los_Angeles');
// date is "2016-02-01T05:00:00-08:00"
 
var date = ai.date.create('2016-02-01 05:00', 'America/Los_Angeles');
// date is "2016-02-01T05:00:00-08:00"
 
// create a date that includes daylight savings
var date = ai.date.create('2016-02-01 12:00', 'Australia/Sydney');
// date is "2016-02-01T12:00:00+11:00"
 
// without daylight savings...
var date = ai.date.create('2016-06-01 12:00', 'Australia/Sydney');
// date is "2016-02-01T12:00:00+10:00"
 
// create a date in UTC
var date = ai.date.create('2016-03-01', 'UTC');
// date is "2016-03-01T00:00:00+00:00"

Converting ISO8601 Datetime Strings

// convert Brisbane to Sydney time with daylight savings
var date = ai.date.convertTimezone(new Date('2015-01-15T12:00:00+10:00'), 'Australia/Sydney');
// date is "2015-01-15T13:00:00+11:00"
 
// convert Brisbane to Sydney time without daylight savings
var date = ai.date.convertTimezone('2015-06-15T12:00:00+10:00', 'Australia/Sydney');
// date is "2015-06-15T12:00:00+10:00"
 
// convert Brisbane to New York time
var date = ai.date.convertTimezone('2015-06-15T12:00:00+10:00', 'America/New_York');
// date is "2015-06-14T22:00:00-04:00"
 
// convert New York to Brisbane time
var date = ai.date.convertTimezone('2015-06-15T12:00:00-04:00', 'Australia/Brisbane');
// date is "2015-06-16T02:00:00+10:00"
 
// convert New York to UTC time
var date = ai.date.convertTimezone('2015-06-15T12:00:00-04:00', 'UTC');  
// date is "2015-06-15T16:00:00+00:00"

Getting Server Timezone

var serverTz = ai.date.getServerTimezone();
// as an example, serverTz = 'America/Los_Angeles'

Getting All Supported Timezones

var timezones = ai.date.getSupportedTimezones();
// timezones is an array containing the above 583 timezones