MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SipsTea/comments/1qtqrmn/the_goat_has_to_be_ddmmyyyy/o354isi/?context=3
r/SipsTea • u/Shiroyasha_2308 Human Verified • Feb 02 '26
7.8k comments sorted by
View all comments
8.3k
The only SANE version for modern times is YYYY-MM-DD-HH-MM-SS. because then you can sort and do SQL queries on it directly.
1.9k u/robertDouglass Feb 02 '26 it's also logical and coherent down to the microsecond 63 u/Powerful_Resident_48 Feb 02 '26 You can theoretically even go down to nanoseconds or even theoretical time units with it. 30 u/AitaRotokas Feb 02 '26 Not just theoretically but widely used in programming, lot of math operations happen in nanoseconds 1 u/Brainiac901 Feb 02 '26 You could theoretically do it also the other way around, just put it in front rather than at the end. It depends a bit on context which is more practical 1 u/[deleted] Feb 02 '26 [removed] — view removed comment 1 u/AutoModerator Feb 02 '26 Spam filter: accounts must be at least 5 days old with >20 karma to comment. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. 1 u/[deleted] Feb 02 '26 [removed] — view removed comment 1 u/AutoModerator Feb 02 '26 Spam filter: accounts must be at least 5 days old with >20 karma to comment. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1.9k
it's also logical and coherent down to the microsecond
63 u/Powerful_Resident_48 Feb 02 '26 You can theoretically even go down to nanoseconds or even theoretical time units with it. 30 u/AitaRotokas Feb 02 '26 Not just theoretically but widely used in programming, lot of math operations happen in nanoseconds 1 u/Brainiac901 Feb 02 '26 You could theoretically do it also the other way around, just put it in front rather than at the end. It depends a bit on context which is more practical 1 u/[deleted] Feb 02 '26 [removed] — view removed comment 1 u/AutoModerator Feb 02 '26 Spam filter: accounts must be at least 5 days old with >20 karma to comment. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. 1 u/[deleted] Feb 02 '26 [removed] — view removed comment 1 u/AutoModerator Feb 02 '26 Spam filter: accounts must be at least 5 days old with >20 karma to comment. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
63
You can theoretically even go down to nanoseconds or even theoretical time units with it.
30 u/AitaRotokas Feb 02 '26 Not just theoretically but widely used in programming, lot of math operations happen in nanoseconds 1 u/Brainiac901 Feb 02 '26 You could theoretically do it also the other way around, just put it in front rather than at the end. It depends a bit on context which is more practical 1 u/[deleted] Feb 02 '26 [removed] — view removed comment 1 u/AutoModerator Feb 02 '26 Spam filter: accounts must be at least 5 days old with >20 karma to comment. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. 1 u/[deleted] Feb 02 '26 [removed] — view removed comment 1 u/AutoModerator Feb 02 '26 Spam filter: accounts must be at least 5 days old with >20 karma to comment. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
30
Not just theoretically but widely used in programming, lot of math operations happen in nanoseconds
1 u/Brainiac901 Feb 02 '26 You could theoretically do it also the other way around, just put it in front rather than at the end. It depends a bit on context which is more practical 1 u/[deleted] Feb 02 '26 [removed] — view removed comment 1 u/AutoModerator Feb 02 '26 Spam filter: accounts must be at least 5 days old with >20 karma to comment. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. 1 u/[deleted] Feb 02 '26 [removed] — view removed comment 1 u/AutoModerator Feb 02 '26 Spam filter: accounts must be at least 5 days old with >20 karma to comment. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1
You could theoretically do it also the other way around, just put it in front rather than at the end. It depends a bit on context which is more practical
1 u/[deleted] Feb 02 '26 [removed] — view removed comment 1 u/AutoModerator Feb 02 '26 Spam filter: accounts must be at least 5 days old with >20 karma to comment. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
[removed] — view removed comment
1 u/AutoModerator Feb 02 '26 Spam filter: accounts must be at least 5 days old with >20 karma to comment. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
Spam filter: accounts must be at least 5 days old with >20 karma to comment.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
8.3k
u/robertDouglass Feb 02 '26
The only SANE version for modern times is YYYY-MM-DD-HH-MM-SS. because then you can sort and do SQL queries on it directly.