Adding the time zone

Question

Adding the time zone

Steve Jones - SSC Editor

SSC Guru

Points: 737475
More actions
September 29, 2018 at 11:11 am

#77355

Comments posted to this topic are about the item Adding the time zone

Viewing 14 posts - 1 through 13 (of 13 total)

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

Robert Eder SSCarpal Tunnel Points: 4244 More actions · Answer 1

Technically, none of the choices are correct. Datetimeoffset is 34 characters in length. The length of @C truncates the value returned and results in "2018-09-03 11:55:34." Changing the length of @C to 34 results in the full datetimeoffset string.

Stewart "Arturius" Campbell SSC Guru Points: 72693 More actions · Answer 2

Nice question to start the week on, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

edwardwill SSCertifiable Points: 5908 More actions · Answer 3

Robert Eder - Saturday, September 29, 2018 6:57 PM
Technically, none of the choices are correct. Datetimeoffset is 34 characters in length. The length of @C truncates the value returned and results in "2018-09-03 11:55:34." Changing the length of @C to 34 results in the full datetimeoffset string.

Exactly. Does no-one ever actually test these things?

amalmathewalex789 SSC Rookie Points: 25 More actions · Answer 4

Hi @steve-2
I think none of the answers are correct.
The varchar size given is 20 and thus it shows only up to "2018-09-03 11:55:34." in the Result set.
If it was given like varchar(34) then the answer would be "2018-09-03 11:55:34.0000000 -07:00"

Thanks

sipas Hall of Fame Points: 3828 More actions · Answer 5

Also, the explanation says:

"The conversion takes place correctly and '2018-09-03 04:55:34.0000000 -07:00' is returned."

Shayn Thomas SSCertifiable Points: 5863 More actions · Answer 6

Robert Eder - Saturday, September 29, 2018 6:57 PM
Technically, none of the choices are correct. Datetimeoffset is 34 characters in length. The length of @C truncates the value returned and results in "2018-09-03 11:55:34." Changing the length of @C to 34 results in the full datetimeoffset string.

+1

---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know

roger.plowman SSChampion Points: 10265 More actions · Answer 7

Shayn Thomas - Monday, October 1, 2018 6:42 AM
Robert Eder - Saturday, September 29, 2018 6:57 PM
Technically, none of the choices are correct. Datetimeoffset is 34 characters in length. The length of @C truncates the value returned and results in "2018-09-03 11:55:34." Changing the length of @C to 34 results in the full datetimeoffset string.
+1