SQL | How to compare date from different time zones? Time Zone conversion | AT TIME ZONE

very useful!

Hey there, glad to meet again.
I learned about timestamp as a date data type.
My question is, if i where to record timestamps of every record entered into the database. Would the sql server generate two identical timestamps given the records where run simultaneously..is that case a hypothetical one or would it happen?
Thanks for taking care of this.

No idea this function existed, thanks for sharing!

Useful function

Very informative