Date/Time Formats

Working with dates and times can be very frustrating. I personally spent forever looking all over the internet for a very specific format. Finally I found it, and unfortunately now I cannot remember where I snagged this table from. However, I thought it could prove useful in the future for either my own future work or others. Let’s be honest, there are far too many to remember!

If/when I find the source location, I’ll include it in the caption below.

Timestamp FormatExample
yyyy-MM-dd’T’HH:mm:ss*SSSZZZZ2018-08-20’T’13:20:10*633+0000
yyyy MMM dd HH:mm:ss.SSS zzz2017 Mar 03 05:12:41.211 PDT
MMM dd HH:mm:ss ZZZZ yyyyJan 21 18:20:11 +0000 2017
dd/MMM/yyyy:HH:mm:ss ZZZZ19/Apr/2017:06:36:15 -0700
MMM dd, yyyy hh:mm:ss aDec 2, 2017 2:39:58 AM
MMM dd yyyy HH:mm:ssJun 09 2018 15:28:14
MMM dd HH:mm:ss yyyyApr 20 00:00:35 2010
MMM dd HH:mm:ss ZZZZSep 28 19:00:00 +0000
MMM dd HH:mm:ssMar 16 08:12:04
yyyy-MM-dd’T’HH:mm:ssZZZZ2017-10-14T22:11:20+0000
yyyy-MM-dd’T’HH:mm:ss.SSS’Z’2017-07-01T14:59:55.711’+0000′
2017-07-01T14:59:55.711Z
yyyy-MM-dd HH:mm:ss ZZZZ2017-08-19 12:17:55 -0400
yyyy-MM-dd HH:mm:ssZZZZ2017-08-19 12:17:55-0400
yyyy-MM-dd HH:mm:ss,SSS2017-06-26 02:31:29,573
yyyy/MM/dd*HH:mm:ss2017/04/12*19:37:50
yyyy MMM dd HH:mm:ss.SSS*zzz2018 Apr 13 22:08:13.211*PDT
yyyy MMM dd HH:mm:ss.SSS2017 Mar 10 01:44:20.392
yyyy-MM-dd HH:mm:ss,SSSZZZZ2017-03-10 14:30:12,655+0000
yyyy-MM-dd HH:mm:ss.SSS2018-02-27 15:35:20.311
yyyy-MM-dd HH:mm:ss.SSSZZZZ2017-03-12 13:11:34.222-0700
yyyy-MM-dd’T’HH:mm:ss.SSS2017-07-22’T’16:28:55.444
yyyy-MM-dd’T’HH:mm:ss2017-09-08’T’03:13:10
yyyy-MM-dd’T’HH:mm:ss’Z’2017-03-12’T’17:56:22′-0700′
yyyy-MM-dd’T’HH:mm:ss.SSS2017-11-22’T’10:10:15.455
yyyy-MM-dd’T’HH:mm:ss2017-02-11’T’18:31:44
yyyy-MM-dd*HH:mm:ss:SSS2017-10-30*02:47:33:899
yyyy-MM-dd*HH:mm:ss2017-07-04*13:23:55
yy-MM-dd HH:mm:ss,SSS ZZZZ11-02-11 16:47:35,985 +0000
yy-MM-dd HH:mm:ss,SSS10-06-26 02:31:29,573
yy-MM-dd HH:mm:ss10-04-19 12:00:17
yy/MM/dd HH:mm:ss06/01/22 04:11:05
yyMMdd HH:mm:ss150423 11:42:35
yyyyMMdd HH:mm:ss.SSS20150423 11:42:35.173
MM/dd/yy*HH:mm:ss08/10/11*13:33:56
MM/dd/yyyy*HH:mm:ss11/22/2017*05:13:11
MM/dd/yyyy*HH:mm:ss*SSS05/09/2017*08:22:14*612
MM/dd/yy HH:mm:ss ZZZZ04/23/17 04:34:22 +0000
MM/dd/yyyy HH:mm:ss ZZZZ 10/03/2017 07:29:46 -0700
HH:mm:ss11:42:35
HH:mm:ss.SSS11:42:35.173
HH:mm:ss,SSS11:42:35,173
dd/MMM HH:mm:ss,SSS23/Apr 11:42:35,173
dd/MMM/yyyy:HH:mm:ss23/Apr/2017:11:42:35
dd/MMM/yyyy HH:mm:ss23/Apr/2017 11:42:35
dd-MMM-yyyy HH:mm:ss23-Apr-2017 11:42:35
dd-MMM-yyyy HH:mm:ss.SSS23-Apr-2017 11:42:35.883
dd MMM yyyy HH:mm:ss23 Apr 2017 11:42:35
dd MMM yyyy HH:mm:ss*SSS23 Apr 2017 10:32:35*311
MMdd_HH:mm:ss0423_11:42:35
MMdd_HH:mm:ss.SSS0423_11:42:35.883
MM/dd/yyyy hh:mm:ss a:SSS8/5/2011 3:31:18 AM:234
MM/dd/yyyy hh:mm:ss a9/28/2011 2:23:15 PM

Leave a Reply

Your email address will not be published.