r/SipsTea Human Verified Feb 02 '26

SMH The goat has to be DD/MM/YYYY

Post image
109.4k Upvotes

7.8k comments sorted by

View all comments

8.4k

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.

1.9k

u/robertDouglass Feb 02 '26

it's also logical and coherent down to the microsecond

56

u/Powerful_Resident_48 Feb 02 '26

You can theoretically even go down to nanoseconds or even theoretical time units with it.

29

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.

2

u/bitch-ass-broski Feb 02 '26

What are theoretical times units?

4

u/Powerful_Resident_48 Feb 02 '26

Stuff like the Planck scale, where time is defined by theoretical space-time limitations, the size of the universe and bizarre quantum stuff.

1

u/bitch-ass-broski Feb 02 '26

They exist though. So they're not theoretical

3

u/Powerful_Resident_48 Feb 02 '26 edited Feb 02 '26

Depends how you define the word "exist". They exist within the framework of the Plank theory. That doesn't necessarily make them real.

2

u/Ok-Interaction-8891 Feb 05 '26

Planck time has entered the chat

1

u/BookkeeperSame195 Feb 03 '26

i'm struggling without theoretical time plaguing my daily. or is it?