Forum Discussion

DanielAmbler's avatar
DanielAmbler
Icon for Helper II rankHelper II
2 years ago
Solved

Converted timestamps using expression functions always have UTC timezone - is this expected?

Hi,   I have some pipeline telemetry i'd like to store as part of a pipeline run.  What I'd like to store is the offset between the converted timestamp and utc.   I am currently testing the timez...
General Question
pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi DanielAmbler ,

    Apologize for the issue you are facing. The best course of action is to open a support ticket and have our support team take a closer look at it: Link 

     

    After creating a Support ticket please provide the ticket number as it would help us to track for more information.

     

    Hope this helps. Please let us know if you have any other queries.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DanielAmbler ,

Thanks for using Fabric Community.
Can you please explain your query little bit? If possible can you please explain with an example?

If you can provide these details, I can guide you better.

 

  • DanielAmbler's avatar
    DanielAmbler
    Icon for Helper II rankHelper II
    2 years ago

    Hi Anonymous ,

     

    Thanks for your reply, sure I can provide more information.  Given this test pipeline

     

     

     

    The first activity sets a timestamp (@utcnow())

    The second converts from utc (

    @convertFromUtc(variables('var_utcnow'), 'GMT Standard Time'))
    The third converts further between timezones (
    @convertTimeZone(variables('var_utc_convert_timezone_1'), 'GMT Standard Time', 'Pacific Standard Time')
     The fourth formats the datetime (
    @formatDateTime(variables('var_convert_timezone_1_timezone_2'), 'yyyy-MM-ddTHH:mm:ss.fffffffzzz'))
     
    In each case the timezone output (regardless of the step) is always 'Z', which as I understand it indicates no difference between the timestamp and UTC.
     
    I am wanting to understand if this is expected behaviour, and if not, is there a known method of obtaining an offset between a timestamp that is converted from UTC to another zone?
     
    Please let me know if I can provide any more information.
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi DanielAmbler ,

      This is an expected behvaiour. 
      Here are my results when I tried to reproduce your scenario.

       



      {
	"name": "var_utcnow",
	"value": "2024-06-13T10:24:21.7790903Z"
}


{
	"name": "var_utc_convert_timezone_1",
	"value": "2024-06-13T11:24:21.7790903Z"
}


{
	"name": "var_convert_timezone_1_timezone_2",
	"value": "2024-06-13T03:24:21.7790903Z"
}


{
	"name": "var_formatted",
	"value": "2024-06-13T03:24:21.7790903Z"
}

       
      Can you please help me understand what are you expecting as output here?