Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

Date/Time Parser Layout Styles

  • reference
March 23, 2025
+ 12
When you create a custom date/time parser with the Couchbase Server Web Console, you must choose a specific layout style for your date/time layouts.

You can choose from the following layout styles for a date/time parser.

Date/time layouts should always be surrounded by quotes.
Layout Style Description Example Layouts

flexiblego

Date/time layouts must be provided with golang specific constants.

A flexiblego date/time layout is not validated automatically by the Server Web Console.

For more information about flexiblego time layout syntax, see Go Date/Time Layout Style Syntax.

"01/02 03:04:05PM '25 -0700"

"Mon Jan _2 15:04:05 MST 2025"

"Monday January 02 15:04:05 -0700 2025"

"2025-01-02T15:04:05Z07:00"

isostyle

Date/time layouts must be provided as ISO date format strings, commonly used in programming languages like Java and Swift.

Letters in the range A-Z and a-z are reserved for layout patterns. Any other characters are considered as a literal part of a date string.

The count of pattern letters determines the specific format.

For more information about isostyle time layout syntax, see ISO Style Date/Time Layout Style Syntax.

"yyyy/MM/dd h:mma"

"dd/MM/yyyy HH:mm:ss"

"yyyy-MM-dd’T’HH:mm:ssXX"

"dd MMMM yy ha z"

"yyyy; MMM dd (EEE) hh:mm:ss.SSSSSaa xx"

percentstyle

Date/time layouts are provided using format specifiers surrounded by % characters, commonly used in programming languages like C and Python.

Any other characters in a layout string are considered literal characters.

For more information about percentstyle time layout syntax, see Percent Style Date/Time Layout Style Syntax.

"%Y/%m/%d %l:%M%p"

"%d/%m/%Y %H:%M:%S"

"%Y-%m-%dT%H:%M:%S%z"

"%d %B %y %l%p %Z"

"%Y; %b %d (%a) %I:%M:%S.%N%P %z"

Go Date/Time Layout Style Syntax

flexiblego and sanitizedgo date/time layouts use the following syntax:

Date Time Component Syntax

Year

4 digit year

2025

2 digit year

25

Month

Unpadded month

1

Zero-padded month

01

Full English month

January

Abbreviated English month

Jan

Unpadded day of the month

2

Space-padded day of the month

_2

Zero-padded day of the month

02

Day

Full English day

Monday

Abbreviated English day

Mon

Space-padded 3 digit day of the year

__2

_52

Zero-padded 3 digit day of the year

002

Hour

Unpadded hour (1-12)

3

Zero-padded 2 digit hour

03

15

AM or PM

AM / PM

am / pm

Minute

Unpadded minute

4

Zero-padded minute

04

Second

Unpadded second

5

Zero-padded second

05

Fraction of a Second

Fraction of a second to a given number of decimal places, including trailing zeroes

,000

Fraction of a second to a given number of decimal places, removing trailing zeroes

,999

Time Zone

Time zone as UTC offset

-07

-0700

-07:00

Z07

Z0700

Z07:00

Percent Style Date/Time Layout Style Syntax

percentstyle date/time layouts use the following syntax:

Date Time Component Example Syntax

Year

4 digit year

2025

%Y

2 digit year

25

%y

Month

Unpadded month

1

%o

Zero-padded month

01

%m

Full English month

January

%B

Abbreviated English month

Jan

%b

Day

Unpadded day of the month

2

%e

Zero-padded day of the month

02

%d

Full English day

Monday

%A

Abbreviated English day

Mon

%a

Hour

Unpadded hour (1-12)

3

%1

Zero-padded 2 digit hour

03

15

%I

AM or PM

AM / PM

am / pm

%p (uppercase)

%P (lowercase)

Minute

Unpadded minute

4

%i

Zero-padded minute

04

%M

Second

Unpadded second

5

%s

Zero-padded second

05

%S

Microseconds and Nanoseconds

Microseconds

15:03:02.000000

.%f

Nanoseconds

15:03:02.000000000000

.%N

Time Zone

Time zone name

UTC

JST

GMT

%Z

Time zone as UTC offset, formatted as +hhmm

+0500

-0600

%z

Time zone as UTC offset, formatted as +hh:mm

+05:00

-06:00

%z:M

Time zone as UTC offset, formatted as +hh:mm:ss

+05:00:00

+06:00:00

%z:S

Time zone as UTC offset, formatted as +hh

+05

-06

%zH

Time zone as UTC offset, formatted as +hhmmss

+050000

-060000

%zS

ISO Style Date/Time Layout Style Syntax

isostyle date/time layouts use the following syntax:

Date Time Component Example Syntax

Year

4 digit year

2025

YYYY / yyyy / uuuu

YYY / yyy / uuu

Y / y / u

2 digit year

25

YY / yy / uu

Zero padded year

02025

YYYYY / yyyyy / uuuuu

The number of Y/y/u characters determines the number of zeroes added before the 4 digit year.

Month

Unpadded month

1

M

Zero-padded month

01

MM

Full English month

January

MMMM

Abbreviated English month

Jan

MMM

Day

Unpadded day of the month

2

d

Zero-padded day of the month

02

dd

Full English day

Monday

EEEE

Abbreviated English day

Mon

E / EE / EEE

Hour

Unpadded hour (1-12)

3

h / K

Zero-padded 2 digit hour

03

15

hh / KK

AM or PM

AM / PM

am / pm

a (uppercase)

aa (lowercase)

Minute

Unpadded minute

4

m

Zero-padded minute

04

mm

Second

Unpadded second

5

s

Zero-padded second

05

ss

Fractions of a second

15:03:02.000000

.S - the number of S’s determines the number of decimal places

Time Zone

Time zone name

UTC

JST

GMT

z / zz / zzz / zzzz

Time zone as UTC offset, formatted as +hhmm

+0500

-0600

XX / xx

Time zone as UTC offset, formatted as +hh:mm

+05:00

-06:00

XXX / xxx

Time zone as UTC offset, formatted as +hh:mm:ss

+05:00:00

+06:00:00

XXXXX / xxxxx

Time zone as UTC offset, formatted as +hh

+05

-06

X / x

Time zone as UTC offset, formatted as +hhmmss

+050000

-060000

XXXX / xxxx

See Also