Datetime format string reference for the format_datetime() function

EZ Exporter supports a function called format_datetime() that can be used in Calculated Fields.

format_datetime(datetime, format_str="%Y-%m-%d %H:%M:%S")

By default, the date and time will be in "yyyy-mm-dd hh:mm:ss" format.

For example, the formula:

format_datetime(to_datetime({{ created_at }}))

Will return something like: 2017-09-28 11:30:22

To change the formatting, simply override the format_str parameter with your desired format using the table below.

For instance, this formula:

format_datetime(to_datetime({{ created_at }}), "%A %B %d, %Y")

Will return something like: Thursday September 28, 2017

Please don't hesitate to contact us if you're having trouble.

Code Meaning Example
%a Weekday as locale’s abbreviated name. Mon
%A Weekday as locale’s full name. Monday
%w Weekday as a decimal number, where 0 is Sunday and 6 is Saturday. 1
%d Day of the month as a zero-padded decimal number. 30
%b Month as locale’s abbreviated name. Sep
%B Month as locale’s full name. September
%m Month as a zero-padded decimal number. 09
%y Year without century as a zero-padded decimal number. 13
%Y Year with century as a decimal number. 2013
%H Hour (24-hour clock) as a zero-padded decimal number. 07
%I Hour (12-hour clock) as a zero-padded decimal number. 07
%p Locale’s equivalent of either AM or PM. AM
%M Minute as a zero-padded decimal number. 06
%S Second as a zero-padded decimal number. 05
%f Microsecond as a decimal number, zero-padded on the left. 000000
%z UTC offset in the form +HHMM or -HHMM (empty string if the the object is naive).
%Z Time zone name (empty string if the object is naive).
%j Day of the year as a zero-padded decimal number. 273
%U Week number of the year (Sunday as the first day of the week) as a zero padded decimal number. All days in a new year preceding the first Sunday are considered to be in week 0. 39
%W Week number of the year (Monday as the first day of the week) as a decimal number. All days in a new year preceding the first Monday are considered to be in week 0. 39
%c Locale’s appropriate date and time representation. Mon Sep 30 07:06:05 2013
%x Locale’s appropriate date representation. 09/30/13
%X Locale’s appropriate time representation. 07:06:05
%% A literal '%' character. %

App: EZ Exporter

Tags: advanced features, functions, reference