DATETIME formatting
Formatting dates & times in published content
DATETIME(timestamp, format, output timezone) is a Conducttr function used to make dates and times look attractive.
timestamp = input; required, uses the format “yyyy-mm-dd hh:mm:ss”
format = output format, e.g. ‘HH:mm:ss’ (see details)
output timezone = timezone for output; optional, defaults to project’s time zone (currently defaults to project owner’s time zone)
Formats
Below are the date-time formatting specifications.
Format | Description |
W | number of the week in the year (Monday is the first day of the week) with leading zero, 00-53 |
w | number of the week in the year (Sunday is the first day of the week) with leading zero, 00-53 |
yy or YY | 2-digit year, e.g. 16 |
yyyy or YYYY | 4-digit year, e.g. 2016 |
M | number of the month without leading zero, e.g. 1 |
MM | number of the month with leading zero, e.g. 01 |
MMM | abbreviated month name, e.g. Jan |
MMMM | full month name, e.g. January |
d or D | day of the month without leading zero, e.g. 1 |
dd or DD | day of the month with leading zero, e.g. 01 |
ddd | abbreviated name of the day of the week, e.g. Sun |
dddd | full name of the day of the week, e.g. Sunday |
h | hours (12-hr format) without leading zero |
hh | hours (12-hr format) with leading zero |
H | hours (24-hr format) without leading zero |
HH | hours (24-hr format) with leading zero |
mm | minutes |
ss | seconds |
SSSSSS | microseconds with leading zeros, 000000-999999 |
p or tt | AM/PM label |
z or Z or TZD | time zone label, e.g. UTC |
zz or ZZ | time zone offset without colon, e.g. +0100 |
zzz or ZZZ | time zone offset with colon, e.g. +01:00 |
Examples
The content body might look like: "You started at |DATETIME(audience.start_time, “HH:mm:ss”, “America/New_York”)| and finished at |DATETIME(audience.end_time, “HH:mm:ss”, “America/New_York”)|."
The example above shows the full-blown version with all the optional function parameters. The short one would look like: "You started at |datetime(audience.start_time)| and finished at |datetime(audience.end_time)|."
The second function parameter specifies the date/time format, and the 3rd one specifies the time zone to use. The time zone can be specified in 2 formats - 'America/New_York' (this is a universally-accepted representation for US Eastern Time).
Other examples are |datetime(audience.end_time, “HH:mm:ss Z (ZZ)”, audience.timezone)| Example result: “04:05:00 PST (-0800)”
|datetime(audience.end_time, “d/M/yyyy, ZZ, HH:mm:ss”, audience.timezone)| Example result: “1/1/2015, -0800, 04:05:00”
|datetime(audience.end_time, “HH:mm:ss Z (ZZ)”, audience.timezone)| Let’s say the audience.end_time is “2015-06-01 12:05:00” instead of “2015-01-01 12:05:00” Example result: “05:05:00 PDT (-0700)” tz_timezones A list of tz_timezones can be found here https://en.wikipedia.org/wiki/List_of_tz_database_time_zones
Last updated