I'm using the sql bank in the region, south brazil, but the time is wrong, it is not in accordance with the time in my region.
I'm using the sql bank in the region, south brazil, but the time is wrong, it is not in accordance with the time in my region.
Hi @PauloJose-7938 , just wanted to check if you need more information on this, if answer helped you can mark it 'Accept Answer'
As you can read here SQL Azure uses UTC time on all data centers.
You can convert UTC to Brazil time using AT TIME ZONE as explained here. See below example:
/* Now Switch to Brasil DateTime: */
SELECT @BrasilDateTime = SWITCHOFFSET(@UTCDate, DATENAME(TZ, @UTCDate
AT TIME ZONE ‘E. South America Standard Time’))
11 people are following this question.