Date-time formatting

Description of date-time formatting in Quadratic.

In Quadratic you can use either preset date-time options or use custom date-time options.

Date-time presets

Date-time presets include the standard formats you'd expect for both date and time.

Custom formatting

A very wide range of custom formatting is supported in Quadratic. The table below reflects all available options for custom formatting.

Spec	Example	Description
%Y	2001	Gregorian year padded to 4 digits. Support from -262144 to 262143.
%C	20	Gregorian year divided by 100, zero-padded to 2 digits.
%y	01	Gregorian year modulo 100, zero-padded to 2 digits.
%m	07	Month number (01-12), zero-padded to 2 digits.
%b	Jul	Abbreviated month name. Always 3 letters.
%B	July	Full month name.
%h	Jul	Same as %b
%d	08	Day number 01-31, zero padded to 2 digits.
%e	8	Same as %d but padded.
%a	Sun	Abbreviated weekday name.
%A	Sunday	Full weekday name.
%w	0	Sunday = 0, Monday = 1, etc.
%u	7	Monday = 1, Tuesday = 2, etc.
%U	28	Week number 00-53, zero padded to 2 digits. Week starting with Sunday.
%W	27	Same as %U, but week 1 starts with Monday instead of Sunday.
%G	2001	Same as %Y but ISO 8601 year number.
%g	01	Same %y but year number in ISO 8601
%V	27	Same as %U but uses the week number in ISO 8601 week date (01-53).
%j	189	Day of the year 001-366, zero padded to 3 digits.
%D	07/08/01	Month/day/year format. Same as %m/%d/%y.
%x	07/08/01	Same as %D except locale date representation.
%F	2001-07-08	Year-month-day format in ISO 8601. Same as %Y-%m-%d.
%v	8-Jul-2001	Day-month-year, same as %e-%b-%Y.
%H	00	Hour number 00-23, zero padded to 2 digits.
%k	0	Same as %H but space padded. Same as %_H.
%I (aye)	12	Hour number in 12 hour clocks 01-12, zero-padded to 2 digits.
%l (el)	12	Same as %I (aye), but space-padded, same as %_I (aye).
%P	am	am or pm in 12-hour clock
%p	AM	AM or PM in 12-hour clocks
%M	34	Minute number 00-59, zero padded to 2 digits.
%S	60	Second number 00-60, zero-padded to 2 digits.
%f	26490000	Number of nanoseconds since last whole second.
%.f	.026490	Decimal fraction of a second.
%.3f	.026	Decimal fraction of a second with a fixed length of 3.
%.6f	.026490	Decimal fraction of a second with a fixed length of 6.
%.9f	.026490000	Decimal fraction of a second with a fixed length of 9.
%3f	026	Decimal fraction of a second like %.3f but without the leading dot.
%6f	026490	Decimal fraction of a second like %.6f but without the leading dot.
%9f	026490000	Decimal fraction of a second like %.9f but without the leading dot.
%R	00:34	Hour-minute format. Same as %H:%M.
%T	00:34:60	Hour-minute-second format. Same as %H:%M:%S.
%X	00:34:60	Locale’s time representation (e.g., 23:13:48).
%r	12:34:60 AM	Locale’s 12 hour clock time. (e.g., 11:11:04 PM). Falls back to %X if the locale does not have a 12 hour clock format.
%Z	ACST	Local time zone name. Skips all non-whitespace characters during parsing. Identical to %:z when formatting.
%z	+0930	Offset from the local time to UTC (with UTC being +0000).
%:z	+09:30	Same as %z but with a colon.
%::z	+09:30:00	Offset from the local time to UTC with seconds.
%:::z	+09	Offset from the local time to UTC without minutes.
%#z	+09	Parsing only: Same as %z but allows minutes to be missing or present.
%c	Sun Jul 8 00:34:60 2001	Locale’s date and time (e.g., Thu Mar 3 23:05:25 2005).
%+	2001-07-08T00:34:60.026490+09:30	ISO 8601 / RFC 3339 date & time format.
%s	994518299	UNIX timestamp, the number of seconds since 1970-01-01 00:00 UTC.
%t		Literal tab (\t).
%n		Literal newline (\n).
%%		Literal percent sign.
%-?		Suppresses any padding including spaces and zeroes. (e.g. %j = 012, %-j = 12)
%_?		Uses spaces as a padding. (e.g. %j = 012, %_j = 12)
%0?		Uses zeroes as a padding. (e.g. %e = 9, %0e = 09)