Share via

Convert timestamp field from GMT to Australian EST time zone, considering DayLight Savings

Krishnamohan Nadimpalli 406 Reputation points
2022-11-08T18:23:01.863+00:00

Hi

I have a column(Date GMT) which is timestamp datatype. I need to write derived column transformation with Date in AEST. We need to consider Daylight savings also

258308-image.png

The following is not working. It is giving same time difference with and without daylight savings

toUTC(toTimestamp(toString(Date GMT)), 'AET')
toString(toUTC(Date GMT,'GMT'),'yyyy-MM-dd HH:mm:ss','AET')
toTimestamp(toString(toUTC(Date GMT,'GMT')),'yyyy-MM-dd HH:mm:ss','AET')

Ask is GMT/UTC to AET catering for day light savings which means after 2nd Sunday of October time difference should change.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,625 questions
Accepted answer
  1. AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator
    2022-11-10T19:08:50.657+00:00

    Hi @Krishnamohan Nadimpalli ,

    Thankyou for using Microsoft Q&A platform and thanks for your query here.

    As I understand your ask, you are trying to convert the timestamp values based on daylight savings. Please let me know if my understanding is incorrect.

    According to this thread , fromUTC(<INPUT TIMESTAMP>,'AET') should work. Could you please check if it helps. Please let us know in any case. Thankyou

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. David Broggy 6,291 Reputation points MVP Volunteer Moderator
    2022-11-08T19:28:39.37+00:00

    Hi there,
    have you tried setting a variable like in this suggestion?

    @convertTimeZone(utcnow(),'UTC','India Standard Time')

    how-can-we-convert-timezone-in-azure-data-factory-to-specified-timezones

Your answer

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