Skip to content

Instantly share code, notes, and snippets.

@petrosagg

petrosagg/date-tests.csv

Last active November 20, 2020 12:15
Show Gist options
  • Save petrosagg/590f79bde3438ed3ee233f96fea90bb1 to your computer and use it in GitHub Desktop.
Save petrosagg/590f79bde3438ed3ee233f96fea90bb1 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL date/time positive testcases
Raw
date-tests.csv
Input Date Style Parsed
January 8, 1999 ymd 1999-01-08
1999-01-08 ymd 1999-01-08
1999-01-18 ymd 1999-01-18
01/02/03 ymd 2001-02-03
19990108 ymd 1999-01-08
990108 ymd 1999-01-08
1999.008 ymd 1999-01-08
J2451187 ymd 1999-01-08
99-Jan-08 ymd 1999-01-08
1999-Jan-08 ymd 1999-01-08
08-Jan-1999 ymd 1999-01-08
Jan-08-1999 ymd 1999-01-08
99 Jan 08 ymd 1999-01-08
1999 Jan 08 ymd 1999-01-08
08 Jan 1999 ymd 1999-01-08
Jan 08 1999 ymd 1999-01-08
99 08 Jan ymd 1999-01-08
1999 08 Jan ymd 1999-01-08
99-01-08 ymd 1999-01-08
1999-01-08 ymd 1999-01-08
99-08-01 ymd 1999-08-01
1999-08-01 ymd 1999-08-01
99 01 08 ymd 1999-01-08
1999 01 08 ymd 1999-01-08
99 08 01 ymd 1999-08-01
1999 08 01 ymd 1999-08-01
January 8, 1999 dmy 1999-01-08
1999-01-08 dmy 1999-01-08
1999-01-18 dmy 1999-01-18
1/8/1999 dmy 1999-08-01
18/1/1999 dmy 1999-01-18
01/02/03 dmy 2003-02-01
19990108 dmy 1999-01-08
990108 dmy 1999-01-08
1999.008 dmy 1999-01-08
J2451187 dmy 1999-01-08
January 8, 99 BC dmy 0099-01-08 BC
1999-Jan-08 dmy 1999-01-08
08-Jan-99 dmy 1999-01-08
08-Jan-1999 dmy 1999-01-08
Jan-08-99 dmy 1999-01-08
Jan-08-1999 dmy 1999-01-08
1999 Jan 08 dmy 1999-01-08
08 Jan 99 dmy 1999-01-08
08 Jan 1999 dmy 1999-01-08
Jan 08 99 dmy 1999-01-08
Jan 08 1999 dmy 1999-01-08
1999 08 Jan dmy 1999-01-08
1999-01-08 dmy 1999-01-08
08-01-99 dmy 1999-01-08
08-01-1999 dmy 1999-01-08
01-08-99 dmy 1999-08-01
01-08-1999 dmy 1999-08-01
1999-08-01 dmy 1999-08-01
1999 01 08 dmy 1999-01-08
08 01 99 dmy 1999-01-08
08 01 1999 dmy 1999-01-08
01 08 99 dmy 1999-08-01
01 08 1999 dmy 1999-08-01
1999 08 01 dmy 1999-08-01
January 8, 1999 mdy 1999-01-08
1999-01-08 mdy 1999-01-08
1999-01-18 mdy 1999-01-18
1/8/1999 mdy 1999-01-08
1/18/1999 mdy 1999-01-18
01/02/03 mdy 2003-01-02
19990108 mdy 1999-01-08
990108 mdy 1999-01-08
1999.008 mdy 1999-01-08
J2451187 mdy 1999-01-08
January 8, 99 BC mdy 0099-01-08 BC
1999-Jan-08 mdy 1999-01-08
08-Jan-99 mdy 1999-01-08
08-Jan-1999 mdy 1999-01-08
Jan-08-99 mdy 1999-01-08
Jan-08-1999 mdy 1999-01-08
1999 Jan 08 mdy 1999-01-08
08 Jan 99 mdy 1999-01-08
08 Jan 1999 mdy 1999-01-08
Jan 08 99 mdy 1999-01-08
Jan 08 1999 mdy 1999-01-08
1999 08 Jan mdy 1999-01-08
1999-01-08 mdy 1999-01-08
08-01-99 mdy 1999-08-01
08-01-1999 mdy 1999-08-01
01-08-99 mdy 1999-01-08
01-08-1999 mdy 1999-01-08
1999-08-01 mdy 1999-08-01
1999 01 08 mdy 1999-01-08
08 01 99 mdy 1999-08-01
08 01 1999 mdy 1999-08-01
01 08 99 mdy 1999-01-08
01 08 1999 mdy 1999-01-08
1999 08 01 mdy 1999-08-01
4714-11-24 BC mdy 4714-11-24 BC
5874897-12-31 mdy 5874897-12-31
Raw
time-tests.csv
Input Parsed
00:00 00:00:00
01:00 01:00:00
02:03 PST 02:03:00
11:59 EDT 11:59:00
12:00 12:00:00
12:01 12:01:00
23:59 23:59:00
11:59:59.99 PM 23:59:59.99
2003-03-07 15:36:39 America/New_York 15:36:39
2003-07-07 15:36:39 America/New_York 15:36:39
23:59:59.999999 24:00:00
24:00:00 24:00:00
Raw
timestamp-tests.csv
Input Date Style Parsed
-infinity mdy -infinity
infinity mdy infinity
epoch mdy 1970-01-01 00:00:00
Mon Feb 10 17:32:01 1997 PST mdy 1997-02-10 17:32:01
Mon Feb 10 17:32:01.000001 1997 PST mdy 1997-02-10 17:32:01
Mon Feb 10 17:32:01.999999 1997 PST mdy 1997-02-10 17:32:02
Mon Feb 10 17:32:01.4 1997 PST mdy 1997-02-10 17:32:01.4
Mon Feb 10 17:32:01.5 1997 PST mdy 1997-02-10 17:32:01.5
Mon Feb 10 17:32:01.6 1997 PST mdy 1997-02-10 17:32:01.6
1997-01-02 mdy 1997-01-02 00:00:00
1997-01-02 03:04:05 mdy 1997-01-02 03:04:05
1997-02-10 17:32:01-08 mdy 1997-02-10 17:32:01
1997-02-10 17:32:01-0800 mdy 1997-02-10 17:32:01
1997-02-10 17:32:01 -08:00 mdy 1997-02-10 17:32:01
19970210 173201 -0800 mdy 1997-02-10 17:32:01
1997-06-10 17:32:01 -07:00 mdy 1997-06-10 17:32:01
2001-09-22T18:19:20 mdy 2001-09-22 18:19:20
2000-03-15 08:14:01 GMT+8 mdy 2000-03-15 08:14:01
2000-03-15 13:14:02 GMT-1 mdy 2000-03-15 13:14:02
2000-03-15 12:14:03 GMT-2 mdy 2000-03-15 12:14:03
2000-03-15 03:14:04 PST+8 mdy 2000-03-15 03:14:04
2000-03-15 02:14:05 MST+7:00 mdy 2000-03-15 02:14:05
Feb 10 17:32:01 1997 -0800 mdy 1997-02-10 17:32:01
Feb 10 17:32:01 1997 mdy 1997-02-10 17:32:01
Feb 10 5:32PM 1997 mdy 1997-02-10 17:32:00
1997/02/10 17:32:01-0800 mdy 1997-02-10 17:32:01
1997-02-10 17:32:01 PST mdy 1997-02-10 17:32:01
Feb-10-1997 17:32:01 PST mdy 1997-02-10 17:32:01
02-10-1997 17:32:01 PST mdy 1997-02-10 17:32:01
19970210 173201 PST mdy 1997-02-10 17:32:01
97FEB10 5:32:01PM UTC ymd 1997-02-10 17:32:01
97/02/10 17:32:01 UTC ymd 1997-02-10 17:32:01
1997.041 17:32:01 UTC mdy 1997-02-10 17:32:01
19970210 173201 America/New_York mdy 1997-02-10 17:32:01
1997-06-10 18:32:01 PDT mdy 1997-06-10 18:32:01
Feb 10 17:32:01 1997 mdy 1997-02-10 17:32:01
Feb 11 17:32:01 1997 mdy 1997-02-11 17:32:01
Feb 12 17:32:01 1997 mdy 1997-02-12 17:32:01
Feb 13 17:32:01 1997 mdy 1997-02-13 17:32:01
Feb 14 17:32:01 1997 mdy 1997-02-14 17:32:01
Feb 15 17:32:01 1997 mdy 1997-02-15 17:32:01
Feb 16 17:32:01 1997 mdy 1997-02-16 17:32:01
Feb 16 17:32:01 0097 BC mdy 0097-02-16 17:32:01 BC
Feb 16 17:32:01 0097 mdy 0097-02-16 17:32:01
Feb 16 17:32:01 0597 mdy 0597-02-16 17:32:01
Feb 16 17:32:01 1097 mdy 1097-02-16 17:32:01
Feb 16 17:32:01 1697 mdy 1697-02-16 17:32:01
Feb 16 17:32:01 1797 mdy 1797-02-16 17:32:01
Feb 16 17:32:01 1897 mdy 1897-02-16 17:32:01
Feb 16 17:32:01 1997 mdy 1997-02-16 17:32:01
Feb 16 17:32:01 2097 mdy 2097-02-16 17:32:01
Feb 28 17:32:01 1996 mdy 1996-02-28 17:32:01
Feb 29 17:32:01 1996 mdy 1996-02-29 17:32:01
Mar 01 17:32:01 1996 mdy 1996-03-01 17:32:01
Dec 30 17:32:01 1996 mdy 1996-12-30 17:32:01
Dec 31 17:32:01 1996 mdy 1996-12-31 17:32:01
Jan 01 17:32:01 1997 mdy 1997-01-01 17:32:01
Feb 28 17:32:01 1997 mdy 1997-02-28 17:32:01
Mar 01 17:32:01 1997 mdy 1997-03-01 17:32:01
Dec 30 17:32:01 1997 mdy 1997-12-30 17:32:01
Dec 31 17:32:01 1997 mdy 1997-12-31 17:32:01
Dec 31 17:32:01 1999 mdy 1999-12-31 17:32:01
Jan 01 17:32:01 2000 mdy 2000-01-01 17:32:01
Dec 31 17:32:01 2000 mdy 2000-12-31 17:32:01
Jan 01 17:32:01 2001 mdy 2001-01-01 17:32:01
Raw
timestamptz-tests.csv
Input Date Style Parsed
-infinity mdy -infinity
infinity mdy infinity
epoch mdy 1970-01-01 00:00:00+00
Mon Feb 10 17:32:01 1997 PST mdy 1997-02-11 01:32:01+00
Mon Feb 10 17:32:01.000001 1997 PST mdy 1997-02-11 01:32:01+00
Mon Feb 10 17:32:01.999999 1997 PST mdy 1997-02-11 01:32:02+00
Mon Feb 10 17:32:01.4 1997 PST mdy 1997-02-11 01:32:01.4+00
Mon Feb 10 17:32:01.5 1997 PST mdy 1997-02-11 01:32:01.5+00
Mon Feb 10 17:32:01.6 1997 PST mdy 1997-02-11 01:32:01.6+00
1997-01-02 mdy 1997-01-02 00:00:00+00
1997-01-02 03:04:05 mdy 1997-01-02 03:04:05+00
1997-02-10 17:32:01-08 mdy 1997-02-11 01:32:01+00
1997-02-10 17:32:01-0800 mdy 1997-02-11 01:32:01+00
1997-02-10 17:32:01 -08:00 mdy 1997-02-11 01:32:01+00
19970210 173201 -0800 mdy 1997-02-11 01:32:01+00
1997-06-10 17:32:01 -07:00 mdy 1997-06-11 00:32:01+00
2001-09-22T18:19:20 mdy 2001-09-22 18:19:20+00
2000-03-15 08:14:01 GMT+8 mdy 2000-03-15 16:14:01+00
2000-03-15 13:14:02 GMT-1 mdy 2000-03-15 12:14:02+00
2000-03-15 12:14:03 GMT-2 mdy 2000-03-15 10:14:03+00
2000-03-15 03:14:04 PST+8 mdy 2000-03-15 11:14:04+00
2000-03-15 02:14:05 MST+7:00 mdy 2000-03-15 09:14:05+00
Feb 10 17:32:01 1997 -0800 mdy 1997-02-11 01:32:01+00
Feb 10 17:32:01 1997 mdy 1997-02-10 17:32:01+00
Feb 10 5:32PM 1997 mdy 1997-02-10 17:32:00+00
1997/02/10 17:32:01-0800 mdy 1997-02-11 01:32:01+00
1997-02-10 17:32:01 PST mdy 1997-02-11 01:32:01+00
Feb-10-1997 17:32:01 PST mdy 1997-02-11 01:32:01+00
02-10-1997 17:32:01 PST mdy 1997-02-11 01:32:01+00
19970210 173201 PST mdy 1997-02-11 01:32:01+00
97FEB10 5:32:01PM UTC ymd 1997-02-10 17:32:01+00
97/02/10 17:32:01 UTC ymd 1997-02-10 17:32:01+00
1997.041 17:32:01 UTC mdy 1997-02-10 17:32:01+00
19970210 173201 America/New_York mdy 1997-02-10 22:32:01+00
19970710 173201 America/New_York mdy 1997-07-10 21:32:01+00
20500710 173201 Europe/Helsinki mdy 2050-07-10 14:32:01+00
20500110 173201 Europe/Helsinki mdy 2050-01-10 15:32:01+00
205000-07-10 17:32:01 Europe/Helsinki mdy 205000-07-10 14:32:01+00
205000-01-10 17:32:01 Europe/Helsinki mdy 205000-01-10 15:32:01+00
1997-06-10 18:32:01 PDT mdy 1997-06-11 01:32:01+00
Feb 10 17:32:01 1997 mdy 1997-02-10 17:32:01+00
Feb 11 17:32:01 1997 mdy 1997-02-11 17:32:01+00
Feb 12 17:32:01 1997 mdy 1997-02-12 17:32:01+00
Feb 13 17:32:01 1997 mdy 1997-02-13 17:32:01+00
Feb 14 17:32:01 1997 mdy 1997-02-14 17:32:01+00
Feb 15 17:32:01 1997 mdy 1997-02-15 17:32:01+00
Feb 16 17:32:01 1997 mdy 1997-02-16 17:32:01+00
Feb 16 17:32:01 0097 BC mdy 0097-02-16 17:32:01+00 BC
Feb 16 17:32:01 0097 mdy 0097-02-16 17:32:01+00
Feb 16 17:32:01 0597 mdy 0597-02-16 17:32:01+00
Feb 16 17:32:01 1097 mdy 1097-02-16 17:32:01+00
Feb 16 17:32:01 1697 mdy 1697-02-16 17:32:01+00
Feb 16 17:32:01 1797 mdy 1797-02-16 17:32:01+00
Feb 16 17:32:01 1897 mdy 1897-02-16 17:32:01+00
Feb 16 17:32:01 1997 mdy 1997-02-16 17:32:01+00
Feb 16 17:32:01 2097 mdy 2097-02-16 17:32:01+00
Feb 28 17:32:01 1996 mdy 1996-02-28 17:32:01+00
Feb 29 17:32:01 1996 mdy 1996-02-29 17:32:01+00
Mar 01 17:32:01 1996 mdy 1996-03-01 17:32:01+00
Dec 30 17:32:01 1996 mdy 1996-12-30 17:32:01+00
Dec 31 17:32:01 1996 mdy 1996-12-31 17:32:01+00
Jan 01 17:32:01 1997 mdy 1997-01-01 17:32:01+00
Feb 28 17:32:01 1997 mdy 1997-02-28 17:32:01+00
Mar 01 17:32:01 1997 mdy 1997-03-01 17:32:01+00
Dec 30 17:32:01 1997 mdy 1997-12-30 17:32:01+00
Dec 31 17:32:01 1997 mdy 1997-12-31 17:32:01+00
Dec 31 17:32:01 1999 mdy 1999-12-31 17:32:01+00
Jan 01 17:32:01 2000 mdy 2000-01-01 17:32:01+00
Dec 31 17:32:01 2000 mdy 2000-12-31 17:32:01+00
Jan 01 17:32:01 2001 mdy 2001-01-01 17:32:01+00
Wed Jul 11 10:51:14 America/New_York 2001 mdy 2001-07-11 14:51:14+00
Wed Jul 11 10:51:14 GMT-4 2001 mdy 2001-07-11 06:51:14+00
Wed Jul 11 10:51:14 GMT+4 2001 mdy 2001-07-11 14:51:14+00
Wed Jul 11 10:51:14 PST-03:00 2001 mdy 2001-07-11 07:51:14+00
Wed Jul 11 10:51:14 PST+03:00 2001 mdy 2001-07-11 13:51:14+00
4714-11-24 00:00:00+00 BC mdy 4714-11-24 00:00:00+00 BC
4714-11-23 16:00:00-08 BC mdy 4714-11-24 00:00:00+00 BC
Sun Nov 23 16:00:00 4714 PST BC mdy 4714-11-24 00:00:00+00 BC
Raw
timetz-tests.csv
Input Parsed
00:01 PDT 00:01:00-07
01:00 PDT 01:00:00-07
02:03 PDT 02:03:00-07
07:07 PST 07:07:00-08
08:08 EDT 08:08:00-04
11:59 PDT 11:59:00-07
12:00 PDT 12:00:00-07
12:01 PDT 12:01:00-07
23:59 PDT 23:59:00-07
11:59:59.99 PM PDT 23:59:59.99-07
2003-03-07 15:36:39 America/New_York 15:36:39-05
2003-07-07 15:36:39 America/New_York 15:36:39-04
23:59:59.999999 PDT 24:00:00-07
23:59:59.9999999 PDT 24:00:00-07
23:59:60 PDT 24:00:00-07
24:00:00 PDT 24:00:00-07
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment