|
I worked on a system where date was stored as
(year << 16) | (month << 8) | (day-of-month)
When looking at the raw data, we used hex.
07E10A05 (07E1-0A-05) would be today's date: 2017-10-05.
Sorted correctly in the indexes and was very easy to interpret for month and day.
I am sure that the implementer of the SQL field was trying to make it user friendly for display.
I guess it HAS to be interpreted based on the local system/DB time zone.
|
|
|
|
|
|
Santa is magic, that can't be the end of him.
|
|
|
|
|
Few more days before Christmas, this reminds me of your post.
|
|
|
|
|
I didn't know that they had Coke way back then.
|
|
|
|
|
Is a spokesman good at straightening bicycle rims?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Tread carefully, OG!
/ravi
|
|
|
|
|
He is getting some radial ideas in his old age.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
Let's be careful we don't puncture his ego.
/ravi
|
|
|
|
|
That shouldn't be a problem, he seems to axle at these things.
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
Yes, I hear it's going around.
/ravi
|
|
|
|
|
Ravi Bhavnani wrote: Yes, I hear
Does it sound like a fender?
"the debugger doesn't tell me anything because this code compiles just fine" - random QA comment
"Facebook is where you tell lies to your friends. Twitter is where you tell the truth to strangers." - chriselst
"I don't drink any more... then again, I don't drink any less." - Mike Mullikins uncle
|
|
|
|
|
I guess wheel see.
... such stuff as dreams are made on
|
|
|
|
|
|
Retired, perhaps?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
I think the wheels are coming off...
|
|
|
|
|
|
you're pedalling some proper nonsense today
Format Success.
Welcome to your new signa&*(gD@@@ @@@@@@*@x@@
|
|
|
|
|
Do you never tyre?
... such stuff as dreams are made on
|
|
|
|
|
Perhaps wheel air our opinions on this chain of puns you've been peddling.
Ravings en masse^ |
---|
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein | "If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010 |
|
|
|
|
|
No, but handy with a talk wrench.
|
|
|
|
|
These puns are starting to torque me.
|
|
|
|
|
That's a relief, I thought some foul mouthed urchin was going to make a comment about jobs and rims.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
You framed that sentence to chain those two taboo words together, and that blew my mind.
|
|
|
|
|
Truer spokes have never been whirred.
If you have an important point to make, don't try to be subtle or clever. Use a pile driver. Hit the point once. Then come back and hit it again. Then hit it a third time - a tremendous whack.
--Winston Churchill
|
|
|
|