@utcnow() nseems to be an hour behind to british time

arkiboys 9,686 Reputation points
2021-09-13T15:43:28.797+00:00

Hello,
When I use @utcnow(), I get an hour behind compared to british time
What do I use to show the british time ?

Thank you

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,879 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 29,996 Reputation points MVP
    2021-09-13T15:48:33.873+00:00

    Hey,
    You can follow the below link :
    https://learn.microsoft.com/en-us/previous-versions/windows/embedded/ms912391(v=winembedded.11)

    for the expression:
    @convertTimeZone(utcnow(),'UTC','India Standard Time')

    replace IST with the corresponding timezons


0 additional answers

Sort by: Most helpful