Does the YYYY-MM-DD HH:MM:SS datetime format have a special name? I am writing a function that returns a date in this format and I'm trying to figure out what to call the function.
DATE_TIME. The most common ISO Date Time Format yyyy-MM-dd'T'HH:mm:ss. SSSXXX — for example, "2000-10-31T01:30:00.000-05:00".
Date formatting Dates are formatted using the following format: "yyyy-MM-dd'T'hh:mm:ss'Z'" if in UTC or "yyyy-MM-dd'T'hh:mm:ss[+|-]hh:mm" otherwise. On the contrary to the time zone, by default the number of milliseconds is not displayed.
I can't find a source, but in my experience (25 years working as a systems programmer in UNIX environments) this format is referred to colloquially among engineers as Yoda Time.
It's not valid ISO 8601 because it uses a space instead of a T
to separate the date and time parts.
It looks a lot like ISO 8601 format, but you can never be too sure with time formats.
I think its a variation on the ISO 8601 format. There is more info regarding the format here:
http://dataeducation.com/blog/input-date-formats
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With