Please help me to understand the given timestamp with Z and with Offset

Question

Please help me to understand the given timestamp with Z and with Offset

Surendiran Balasubramanian 1

Hi Team,

Please help me to understand what is the difference between below timestamp

2022-07-22T09:25:47.291Z

2022-07-22T09:25:47.2910000 +00:00

LiHongMSFT-4306 31,571 Reputation points

2022-08-16T05:51:02.277+00:00

Hi ＠SurendiranBalasubramanian-5094
Do you have further question on this issue , could we offer more support?
If this any answer helps, you could mark it as answer so other user with similar problem could see this easier. :)

2 answers

Your answer

LiHongMSFT-4306 31,571 Reputation points

2022-08-16T05:51:02.277+00:00

Hi ＠SurendiranBalasubramanian-5094
Do you have further question on this issue , could we offer more support?
If this any answer helps, you could mark it as answer so other user with similar problem could see this easier. :)

Answer 1

Bruce (SqlWork.com) 78,006 Volunteer Moderator

if the timezone is not specified, then it assumed to be the current timezone (with a database, the timezone specified on the hosting server):

2022-07-22T09:25:47.2910000 (note: the trailing zeros are meaningless, you can include as many decimal places as you want)

but you can also include the timezone so its not ambiguous. the Z stands for Zulu or GMT time. as stated above, this is the same as " +00:00" offset from GTM. unlike the the offset, you do not include a space

Answer 2

Tom Phillips 17,771

There is no difference. "Z" means "+00:00"

See:
https://learn.microsoft.com/en-us/sql/t-sql/data-types/datetimeoffset-transact-sql?view=sql-server-ver16#supported-string-literal-formats-for-datetimeoffset

Share via

Please help me to understand the given timestamp with Z and with Offset

2 answers

Your answer