DATETIME - 4

Question

DATETIME - 4

Viewing 15 posts - 16 through 29 (of 29 total)

You must be logged in to reply to this topic. Login to reply

Primo Dang SSCrazy Points: 2643 More actions · Answer 1

L' Eomot Inversé (3/16/2013)
Nice question, and fine explanation, but that bit about "59.005" seems to have come from a different than the rest. 😉

I thought that part was weird too, made me think longer about the answer as though it was some kind of trick question, but then I decided to go with the answer that made more sense to me and got it right. =]

Thanks for yet another fine question, Ron!

Rose Bud Hall of Fame Points: 3147 More actions · Answer 2

sknox (3/18/2013)
I'm curious: What was the point of the cursor-like WHILE and incrementing the ID by 3? Just Obfuscation? Why didn't you just write the query as:
SELECT ID AS 'Select number', DATETIMEFROMPARTS ([Year],M,D,H,Mi,S,Ms) AS 'Datetime'
,CAST(S AS CHAR(2)) + ':' + CAST(Ms AS CHAR(3)) AS 'Original seconds input'
FROM #T

I have the same question as sknox, except I might add an "order by" to his proposed query.

Sathishk Right there with Babe Points: 738 More actions · Answer 3

Sathishk

Right there with Babe

Points: 738

March 18, 2013 at 9:37 am

#1598086

Nice question, I learnt something new today

Ken SSCoach Points: 17191 More actions · Answer 4

Nice question. I've hit that precision issue before so I guessed correctly. I like that 2012 datefromparts function too.

Revenant SSC-Forever Points: 42467 More actions · Answer 5

Revenant

SSC-Forever

Points: 42467

March 18, 2013 at 11:20 am

#1598120

Nice one... Thanks, Ron!

Miles Neale SSChampion Points: 13147 More actions · Answer 6

I missed it, but still a nice one... Thanks, Ron!

Not all gray hairs are Dinosaurs!

Dineshbabu Hall of Fame Points: 3220 More actions · Answer 7

Nice question and i learned about accuracy and 2012 function(DATETIMEFROMPARTS). I don't know how this accuracy will help me in production..

What I feel is Instead of assigining values to all variables in seperate select statement,Either could have done it in single select or as shokx said straight away could written in one statement..

--
Dineshbabu
Desire to learn new things..