tags:

views:

93

answers:

5
+2  Q: 

what do you call a date/time with a T in the middle (2008-09-18T00:00:00)?

If you have a date like '2008-09-18T00:00:00' does it have a name? UTC? Something like that? Surprisingly hard to google for this...

+2  A: 

That looks like RFC 3339.

Aaron Brethorst  2010-01-04 23:00:05
+8  A: 

That is a combined date/time representation as defined by ISO8601. It often has a timezone/offset appended to it, e.g. 2008-09-18T00:00:00Z would denote UTC time.

Michael Haren  2010-01-04 23:00:33
+1  A: 

ISO 8601 is also relevant: Link

Jeff  2010-01-04 23:04:03
Wow... beat me by 6 seconds... +1
md5sum  2010-01-04 23:04:46
A: 

Also might be ISO-8601.

md5sum  2010-01-04 23:04:09
+1  A: 

Surprisingly I get the correct Wikipedia article as the second hit with this Google search.

paprika  2010-01-04 23:08:08
I might add that the first hit also mentions ISO 8601, but does this probably just because of the search terms "time" and "format", whereas the second hit shows up specifically because of the "T" -- at least it seems so judging by Google's highlighting of the found text excerpts.
paprika  2010-01-04 23:15:31

related questions

Handling and storing elapsed time
How do I convert local time to UTC in Python?
Mono's DateTime Serialization
Best practices for DateTime serialization in .Net framework 3.5/SQL Server 2008
Parsing exact dates in C# shouldn't force you to create an IFormatProvider
C# Casting vs. Parse
.NET Date Const (with Globalization)
Dynamic regex for date time formats
What is the simplest way to find the difference between 2 times in python?
Best way to convert DateTime to "n Hours Ago" in SQL
What's a good way to overwrite DateTime.Now during testing?
Datetime arithmetic with a string in Ruby
How can I get the DateTime for the Start of the Week?
Is DateTime.Now the best way to measure a function's performance?
SQL Server DateTime conversion failure
Natural language date/time parser for .NET?
What's a good way to check if two datetimes are on the same calendar day in TSQL?
Why does this python date/time conversion seem wrong?
Dealing with PHP server and MySQL server in different time zones
How do I parse and convert DateTime's to the RFC 3339 date-time format?
HOWTO - Compare a date string to datetime in SQL Server?
Best method for varchar date validation in Sybase (T-SQL)?
What's the BEST way to remove the time portion of a datetime value (SQL Server)
How do I calculate relative time?
How do I calculate someone's age in C#?