I'm looking for a story I read some time ago. It centers around a woman abducted from earth and transported to a world where she and other non-magical girls are trained as ponygirls and ridden into battle by the native nobles.
I'm looking for a story I read some time ago. It centers around a woman abducted from earth and transported to a world where she and other non-magical girls are trained as ponygirls and ridden into battle by the native nobles.
That's an interesting definition of "some time ago" - it started around the end of April and the most recent chapter was posted two months ago.
That's an interesting definition of "some time ago"
Personally I would interpret "some time ago" as an unknown time ago somewhere between yesterday and 01/01/0001.
About as useful as describing something as bigger than a toaster and smaller than a quasar.
And the starting date you chose identifies you as a DB2 kind of guy
The system I work on (Not DB2) stores dates as a 32 bit signed integer offset (in number of days) from 1/1/1970. A date/time value is two 32 bit integers.
I detest using 1/1/1970 as a default or "null" date because the client I work for actually has operational equipment in the field that old.
Interestingly, that system I work on will accept 1/1/0000 as a valid date value. Yes, I reported it to the vendor as a bug but they aren't interested in fixing it.
Interestingly, that system I work on will accept 1/1/0000 as a valid date value. Yes, I reported it to the vendor as a bug but they aren't interested in fixing it.
As long as you don't divide by year I doubt you will encounter a problem with that.
As long as you don't divide by year I doubt you will encounter a problem with that.
Mathematically it's not a problem, but it's not a valid date. The modern calendar would go from 12/31/0001 BCE to 01/01/0001 CE There is no year zero.
Mathematically it's not a problem, but it's not a valid date. The modern calendar would go from 12/31/0001 BCE to 01/01/0001 CE There is no year zero.
Doesn't matter, you should always validate input thus preventing a year 0000 to ever be stored. So like you said, the validation failed, not the fact that a 0000 year can be stored.
Well, any dates prior to Friday 15 October 1582 are not valid dates under our calendar (Gregorian).
I once designed some RTC hardware & software, where year 0000 was detected to catch if the RTC had not yet been initialised (on first power-up, or changing the RTC batteries with an incorrect procedure). Year 0 can be a valid value, but not in the real world.
This was around 1983, and I realised there would be no need to deal with the century leap year because Y2K was a leap year, and I was able to use the 'day changed' flag to drive a simple calendar with a leap year every 4th which would be correct to 2099, and I didn't think a bit of non-critical office kit would still be in use then (and even then, you could set the date anyway).
For computer and calendar geeks:
I found this very true to my own experience -- https://www.youtube.com/watch?v=-5wpm-gesOY
Never had to deal with that. Every system I've dealt with stores times in GMT/UCT and only deals with time zones for display purposes.
I'll join in as an OLD fart here. When I had a chance at a clean systen I had sufficient seniority to REQUIRE dates to be stored as YYYYMMDD (extracted). Our company had operations in both Europe & Japan and I WAS NOT going to perpetuate the conversion/sorting problems with those [expletive deleted] formats. When asked by a manager type why I didn't use a packaged black-box, I challenged him to show me a way that the YMD format would sort wrong. He went away, silently!
Amazing how I still feel so strongly about this ... (grin)!
to REQUIRE dates to be stored as YYYYMMDD (extracted).
...
Amazing how I still feel so strongly about this ... (grin)!
That's how I still store dates. INT for just a date (YYYYMMDD UTC), BIGINT for datetime (YYYMMDDhhmmssfff UTC). There's no difference in required database storage space compared to the DATE data types so this way keeps is perfectly sortable AND remains human readable.
That's an interesting definition of "some time ago"
he sounds like he might be like me - I used to have a great memory, but I put it down somewhere and can't remember where. However, my forgettery works too damn well.
That's an interesting definition of "some time ago"
"Time is an illusion, lunchtime doubly so." D.A.
Would make time travel to the year zero very interesting. Maybe a different universe? Just before the creation of the universe. Requires some handwavium by the author of a story about visiting year zero.
Would make time travel to the year zero very interesting. Maybe a different universe? Just before the creation of the universe. Requires some handwavium by the author of a story about visiting year zero.
Nope, all it takes is a different calendar :D