The date format can be defined by:

  • Year: yyyy
  • Month: MM, MMM, MMMM
  • Day: dd
  • Hour: HH, hh, h
  • Minutes: mm
  • Seconds: ss
  • AM/PM: tt
  • Time Zone

The following table displays some example Custom Format options for Date and Time Columns.

Custom Format

Result

MM/dd/yyyy

05/15/2008

YYYY-MM-DDTHH:MM:SSZ

2008-04-17T12:00:00Z

dddd, dd MMMM yyyy

Thursday, 15 May 2008

dddd, dd MMMM yyyy HH:mm

Thursday, 15 May 2008 09:35

dddd, dd MMMM yyyy hh:mm tt

Thursday, 15 May 2008 09:35 AM

dddd, dd MMMM yyyy H:mm

Thursday, 15 May 2008 9:35

dddd, dd MMMM yyyy h:mm tt

Thursday, 15 May 2008 9:35 AM

dddd, dd MMMM yyyy HH:mm:ss

Thursday, 15 May 2008 09:35:17

MM/dd/yyyy HH:mm

05/15/2008 09:35

MM/dd/yyyy hh:mm tt

05/15/2008 09:35 AM

MM/dd/yyyy H:mm

05/15/2008 9:35

MM/dd/yyyy h:mm tt

05/15/2008 9:35 AM

MM/dd/yyyy HH:mm:ss

05/15/2008 09:35:17

MMMM dd

May 15

yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK

2008-05-15T09:35:17.2878075-04:00

ddd, dd MMM yyyy HH':'mm':'ss 'GMT'

Thu, 15 May 2008 09:35:17 GMT

yyyy'-'MM'-'dd'T'HH':'mm':'ss

2008-05-15T09:35:17

HH:mm

09:35

hh:mm tt

09:35 AM

HH:mm:ss

09:35:17

yyyy'-'MM'-'dd HH':'mm':'ss'

2008-05-15 09:35:17

yyyy MMMM

2008 May

Was this article useful?

Back to Top