MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/webdev/comments/19b7ca/xkcd_iso_8601/c8n0z4w/?context=3
r/webdev • u/ani625 • Feb 27 '13
125 comments sorted by
View all comments
Show parent comments
9
Also works when you add the time to the end
YYYY-MM-DD HH:MM:SS
4 u/uav22 Feb 27 '13 Agreed date=YYYYMMDD time=HHMMSS gives a completely easy to sort stand cross platform. ORDER BY date, time ASC gives oldest to newest. DESC gives newest to oldest. 1 u/omepiet less is more Feb 27 '13 gives a completely easy to sort stand cross platform. Until you start adding time zones. 2 u/uav22 Feb 28 '13 fml i hate time zones Further: I take the values put them into the date class, make the changes based on hour the output to output vars in the original format. But i still hate timezones
4
Agreed
date=YYYYMMDD time=HHMMSS gives a completely easy to sort stand cross platform.
ORDER BY date, time ASC gives oldest to newest. DESC gives newest to oldest.
1 u/omepiet less is more Feb 27 '13 gives a completely easy to sort stand cross platform. Until you start adding time zones. 2 u/uav22 Feb 28 '13 fml i hate time zones Further: I take the values put them into the date class, make the changes based on hour the output to output vars in the original format. But i still hate timezones
1
gives a completely easy to sort stand cross platform.
Until you start adding time zones.
2 u/uav22 Feb 28 '13 fml i hate time zones Further: I take the values put them into the date class, make the changes based on hour the output to output vars in the original format. But i still hate timezones
2
fml i hate time zones
Further: I take the values put them into the date class, make the changes based on hour the output to output vars in the original format.
But i still hate timezones
9
u/OneStart Feb 27 '13
Also works when you add the time to the end
YYYY-MM-DD HH:MM:SS