Share via

current datetime

arkiboys 9,711 Reputation points
2021-10-19T10:11:53.447+00:00

Hello,
I am usingthe following expression but I see it showing one hour behind.
I would like to see the current uk datetime

This is what I am using at present inside the dataflow --> fromUTC(currentUTC(), 'GBT')

Thank you

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

0 comments No comments

Answer accepted by question author

Nasreen Akter 10,896 Reputation points Volunteer Moderator
2021-10-19T14:21:47.187+00:00

Hi @arkiboys ,

Would you please try the following. Thanks!

fromUTC(currentUTC(), 'Europe/London')   

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. HimanshuSinha 19,637 Reputation points Microsoft Employee Moderator
    2021-10-21T21:06:35.21+00:00

    Hi @arkiboys ,

    Just to clear is fromUTC(currentUTC(), 'GBT') is one hour behind , then fromUTC(currentUTC(), 'Europe/London') is the expression which you are looking for ( as suggested by @Nasreen Akter , Thanks @Nasreen Akter ) .

    I am just adding the screenshot for more clarity for other team members .

    142566-image.png

    Please do let me know how it goes .
    Thanks
    Himanshu

    -------------------------------------------------------------------------------------------------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.