ansaurus

Question

What's the result of the SQL statement "SELECT DATEADD(s,1234567890, '19700101')"?

Answer 1

+3 A:

I get this:

2009-02-13 23:31:30.000

casperOne 2009-02-13 17:43:13

Interesting. That looks familiar... :)

Drew Noakes 2009-02-13 17:44:19

Answer 2

+2 A:

DATE_ADD (not DATEADD) has just two arguments.

Gumbo 2009-02-13 17:47:35

I guess it depends upon which SQL you use. At any rate, the result quoted above looks familiar today for some reason...

Drew Noakes 2009-02-13 17:51:22

Maybe I misread “my SQL” as MySQL.

Gumbo 2009-02-13 18:01:33

Haha, sorry about that. MyMISTAKE :)

Drew Noakes 2009-02-13 18:04:19

Answer 3

A:

Total awesomeness!

Robin Day 2009-02-13 17:50:55

Robin, I award you the correct answer for this question for being so astute :) I couldn't believe this when I saw it. Geeks the world over should have a second's silence.

Drew Noakes 2009-02-13 17:53:11

Question will be closed once people actually realise what you're on about unfortunately.

Robin Day 2009-02-13 17:57:03

Robin -- I'll give you the answer tomorrow just to lure more people to this question in the meantime. Shame that SO doesn't show the date that the question is asked, just how long ago.

Drew Noakes 2009-02-13 17:58:30

I don't see why it should be closed. It's a real question about programming.

Drew Noakes 2009-02-13 17:59:08

How about you get a life and ask some real programming question instead of some trivia that's been around the nets for weeks.

DV 2009-02-13 21:22:56

Thank you DV for your feedback. Very valuable.

Drew Noakes 2009-02-14 03:27:36

Answer 4

+1 A:

more geekiness (not mine)

Moose 2009-02-13 17:55:52

Great stuff, thanks!

Drew Noakes 2009-02-13 17:59:52

ansaurus

tags:

views:

answers:

What's the result of the SQL statement "SELECT DATEADD(s,1234567890, '19700101')"?

related questions