All categories
System
Billing and policy
Built-in apps
Business Intelligence
Business Operations and ERPs
Calendar addon
Commerce
Communication
Contacts module
CRM and Sales tools
Customer Support
Database
Education
Exclusive apps
Features
File and Document Management
Getting started with Boost.space
HR management
Internet of Things
IT and Development
Lifestyle
Marketing
Modules and Addons
News monitor addon
Notes addon
Other
Pages addon
Process Management
Productivity
Products module
Records
Spaces
Surveys and Forms
System Settings (for Admins)
Tasks module
Travel
Users and teams
Wall addon
Warehouses addon
Website Building
Work hours addon
Integrations
Connections
Errors
Functions
Getting started with Boost.space Integrator
Integrator Modules
Language tools
Mapping
Scenarios
Tools
Tutorials
List of applications
Table of Contents

Tokens for date/time formatting

Use date/time formatting tokens to change the format of date/time data. For example, you can convert a timestamp to a quarter of the year or day of the week. The following tables present the tokens supported for changes in formatting.

Year, month, and day tokens

 

Token Output Description
YY 70 71 ... 29 30 2 digit year
YYYY 1970 1971 ... 2029 2030 4 digit year
Y 1970 1971 ... 9999 +10000 +10001 Year with any number of digits and sign
Q 1 2 3 4 Quarter of year
Qo 1st 2nd 3rd 4th Quarter of year with ordinal
M 1 2 ... 11 12 Month number
Mo 1st 2nd ... 11th 12th Month with ordinal
MM 01 02 ... 11 12 Month number with leading zero
MMM Jan Feb ... Nov Dec Month abbreviation
MMMM January February ... November December Month name
D 1 2 ... 30 31 Day of month
Do 1st 2nd ... 30th 31st Day of month with ordinal
DD 01 02 ... 30 31 Day of month with leading zero
DDD 1 2 ... 364 365 Day of year
DDDo 1st 2nd ... 364th 365th Day of year with ordinal
DDDD 001 002 ... 364 365 Day of year with leading zero

Week year, week, and weekday tokens

 

Token Output Description
d 0 1 ... 5 6 Day of week
do 0th 1st ... 5th 6th Day of week with ordinal
dd Su Mo ... Fr Sa Day abbreviation
ddd Sun Mon ... Fri Sat Day abbreviation
dddd Sunday Monday ... Friday Saturday Day name
E 1 2 ... 6 7 Day of week (ISO)
w 1 2 ... 52 53 Week of year
wo 1st 2nd ... 52nd 53rd Week of year with ordinal
ww 01 02 ... 52 53 Week of year with leading zero
W 1 2 ... 52 53 Week of year (ISO)
Wo 1st 2nd ... 52nd 53rd Week of year with ordinal (ISO)
WW 01 02 ... 52 53 Week of year with leading zero (ISO)
gg 70 71 ... 29 30 Week year
gggg 1970 1971 ... 2029 2030 Week year
GG 70 71 ... 29 30 Week year (ISO
GGGG 1970 1971 ... 2029 2030 Week year (ISO)

Hour, minute, second, millisecond, and offset tokens

 

Token Output Description
H 0 1 ... 22 23 24 hour time
HH 00 01 ... 22 23 24 hour time with leading zero
h 1 2 ... 11 12 12 hour time
hh 01 02 ... 11 12 12 hour time with leading zero
k 1 2 ... 23 24 24 hour time
kk 01 02 ... 23 24 24 hour time with leading zero
A AM PM Post or ante meridiem (upper case)
a am pm Post or ante meridiem (lower case)
m 0 1 ... 58 59 Minutes
mm 00 01 ... 58 59 Minutes with leading zero
s 0 1 ... 58 59 Seconds
ss 00 01 ... 58 59 Seconds with leading zero
S 0 1 ... 8 9 Fractional seconds
SS 00 01 ... 98 99 Fractional seconds with leading zero
SSS 000 001 ... 998 999 Fractional seconds with two leading zeros
SSSS ... SSSSSSSSS 000[0..] 001[0..] ... 998[0..] 999[0..] Fractional seconds
Z -07:00 -06:00 ... +06:00 +07:00 Time zone
ZZ -0700 -0600 ... +0600 +0700 Time zone
X 1360013296 Unix Timestamp
x 1360013296123 Unix Millisecond Timestamp