Skip to main content
Software Engineering

Return to Question

Post Timeline

Tweeted twitter.com/StackSoftEng/status/1046278668669071360
Removed introductory fluff
Source Link
edit approved Sep 28, 2018 at 19:18
TylerH
edit approved Sep 28, 2018 at 19:18
TylerH
  • 105
  • 4

The title is self explanatory. Sorry if that sounds like a newbie question, but I just can't seem to find the answer anywhere else.

Is there any engineering reason why is it like that? I was wondering in the case of a RDBMS that it had something to do with performance, since a "YEAR" is more specific than a "MONTH", for instance: you only have one year 2000, but every year have "January", which would make it easier/faster to filter/sort something by year first, and that's why the year comes first.

But I don't know if that really makes sense... Is there any reason at all?

The title is self explanatory. Sorry if that sounds like a newbie question, but I just can't seem to find the answer anywhere else.

Is there any engineering reason why is it like that? I was wondering in the case of a RDBMS that it had something to do with performance, since a "YEAR" is more specific than a "MONTH", for instance: you only have one year 2000, but every year have "January", which would make it easier/faster to filter/sort something by year first, and that's why the year comes first.

But I don't know if that really makes sense... Is there any reason at all?

Is there any engineering reason why is it like that? I was wondering in the case of a RDBMS that it had something to do with performance, since a "YEAR" is more specific than a "MONTH", for instance: you only have one year 2000, but every year have "January", which would make it easier/faster to filter/sort something by year first, and that's why the year comes first.

But I don't know if that really makes sense... Is there any reason at all?

Notice added Needs detailed answers by maple_shaft♦
Question Protected by gnat
Source Link
lucaswxp
lucaswxp
  • 1.4k
  • 2
  • 8
  • 11

Is there any technical reason why, in programming, the default date format is YYYYMMDD and not something else?

The title is self explanatory. Sorry if that sounds like a newbie question, but I just can't seem to find the answer anywhere else.

Is there any engineering reason why is it like that? I was wondering in the case of a RDBMS that it had something to do with performance, since a "YEAR" is more specific than a "MONTH", for instance: you only have one year 2000, but every year have "January", which would make it easier/faster to filter/sort something by year first, and that's why the year comes first.

But I don't know if that really makes sense... Is there any reason at all?