Java SimpleDateFormat: Difference between revisions
Jump to navigation
Jump to search
(→UTC) |
|||
Line 50: | Line 50: | ||
=UTC= | =UTC= | ||
Use [time zone|java SimpleDateFormat#Time_Zone] (see above) and "0000". | Use [[time zone|java SimpleDateFormat#Time_Zone]] (see above) and "0000". | ||
Examples: | Examples: | ||
Line 65: | Line 65: | ||
15/01/01 01:01:01-0700 | 15/01/01 01:01:01-0700 | ||
</pre> | </pre> | ||
=Z in Time Stamp= | =Z in Time Stamp= |
Revision as of 17:50, 22 January 2016
External
Internal
Samples
"yy/MM/dd hh:mm:ss,SSS a"
produces:
13/01/31 01:00:00,000 PM
Excel, CSV and milliseconds
Excel understands "." so you may want to:
13/01/31 01:00:00.000
Hour in Day
Warning If not using AM/PM (no "a" in the format), make sure you use HH for hours (instead of hh).
According to the documentation:
- "h" - Hour in am/pm (1-12)
- "H" - Hour in a day (0-23)
Time Zone
Z
for -0800
Just one single "Z" not four or five.
UTC
Use java SimpleDateFormat#Time_Zone (see above) and "0000".
Examples:
This is UTC.
15/01/01 01:01:01+0000
This is PDT.
15/01/01 01:01:01-0700
Z in Time Stamp
"Z" means GMT in ISO 8601
To parse that, add "X" in the pattern.
Various Examples
"2015-09-22T18:03:46Z" is parsed by "yyyy-MM-dd'T'HH:mm:ssX"