Comments | tigertosser: Would YOU date oracle?

tigertosser

Would YOU date oracle?

Jan 27, 2009 11:39

So recently, like a few months ago I discovered that Oracle uses something retarded for dates. 1970/1/1 ? WTF? WHY? Why would they do that? It's so confusing and annoying to work with. Having to figure out shit in a billion different databases makes me cry.

Comments 14

cat_gone_astray January 27 2009, 23:30:34 UTC

Which one is the month and which one is the date? I remember writing dates with year month day in school, biggest to smallest! I think we did them that way in French, but I might be mistaken.

tigertosser January 28 2009, 01:48:56 UTC

No see, i didn't explain myself properly, I was at work. Oracle bases their dates off how many seconds from 1970/1/1 it is. So right now it's at some retardedly huge number that takes up a lot of space due to this.

floorpirate January 28 2009, 02:15:05 UTC

That's.... the worst method of keeping time/date I've ever seen.

tigertosser January 28 2009, 02:28:45 UTC

I'm sure there's some better explanation. I bet Sloot could clarify.

Thread 11

t0yb0x January 28 2009, 05:10:04 UTC

I wouldn't date Oracle and would most likely throw my hands up in the air, grumble to myself, and walk away.

WTF is with that? It makes no sense to do the dates like that.

tigertosser January 28 2009, 12:22:49 UTC

Yeah, and apparently AS400 boxes do the same thing. Of course I could be just pulling this shit out of my ass and misunderstanding people..

That's unixtime insaner6 January 29 2009, 21:46:15 UTC

It's actually pretty standard (unixtime). In fact i've been using it for years. MySQL has some nice built in functions to deal with it.. it comes in handy for date calculations (down to the second ( ... )