Forum Discussion

arpost's avatar
arpost
Post Prodigy
2 years ago

How do you store DateTimeTimezone without DATETIMEOFFSET?

Greetings, community. I am working to move some Gen 1 dataflows over and have the data stored in a Fabric data warehouse. The data has date/time values with user-specific timezone offsets listed (2024-02-07T09:15:00-07:00).

 

Given that Fabric DW doesn't have the DATETIMEOFFSET data type, I'm not sure what the best alternative approach is to handle different time zones. Anyone have suggestions?

data engineering
Data Integration
data warehouse

5 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi arpost 

     

    At this time, we are reaching out to the internal team to get some help on this .
    We will update you once we hear back from them.
    Appreciate your patience.

     

    Thanks.

    • v-cboorla-msft's avatar
      v-cboorla-msft
      Microsoft Employee
      2 years ago

      Hi arpost 

       

      Apologies for the inconvenience.

      Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

      Please go ahead and raise a support ticket to reach our support team:

      https://support.fabric.microsoft.com/support

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

       

      Thank you.

      • arpost's avatar
        arpost
        Post Prodigy
        2 years ago

        v-cboorla-msft, thanks for the reply. I thought I was instructed by some Microsoft support previously that MS Support is for technical support (e.g., there's a bug) as opposed to advisory help (e.g., how do I accomplish X in Fabric). Has that changed? I'm perfectly happy to send a ticket and get some advice on how to use Fabric for this use-case.