Date/Time format rules

Owned by Former user (Deleted)
Last updated: Apr 04, 2019 by svitlana (Deactivated)
1 min read

This page includes details about Date format options, available in Date, Time and DateTime columns.


You can use any of available types to specify a format of date displayed in Date, Time and DateTime column type.

Default date format is L. Default time format is hh:mm A

There are some predefined format presents based on locale available.

 

 Date format specifications

Category

Format

Example

Category

Format

Example

Weekday

d

0..6

dd

Su

ddd

Sun

dddd

Sunday

Year

YY

17

YYYY

2017

Month

M

1..12

Mo

1st..12th

MM

01..12

MMM

Jan

MMMM

January

Quarter

Q

1..4

Qo

1st..4th

Day

D

1..31

Do

1st..31st

DD

01..31

Day of year

DDD

1..365

DDDo

1st..365th

DDDD

001..365

Week of year

w

1..53

wo

1st..53rd

ww

01..53

 

 Time format specifications

Category

Format

Example

Category

Format

Example

AM/PM

A

AM PM

a

am pm

Hour





H

0 1 ... 22 23

HH

00 01 ... 22 23

h

1 2 ... 11 12

hh

01 02 ... 11 12

k

1 2 ... 23 24

kk

01 02 ... 23 24

Minute

m

0 1 ... 58 59

mm

00 01 ... 58 59

Second

s

0 1 ... 58 59

ss

00 01 ... 58 59

 

Predefined date and time presets based on locale

Format preset

Example (en locale)

Example (de locale)

Format preset

Example (en locale)

Example (de locale)

LT

8:30 PM

20:30

LTS

8:30:25 PM

20:30:25

L

08/02/1985

02.08.1985

l

8/02/1985

02.8.1985

LL

August 2

1985

2. August 1985

ll

Aug 2

1985

2. Aug. 1985