community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More

Date Time Conversion (GMT/UTC to EST with DST)

Atom

I need to convert my in-DB (SQL server) date time data, represented as the number of milliseconds since 01/01/1970 (GMT/UTC), to EST while accounting for daylight savings. The "EVENT_DATE" field is FixedDecimal data type. I currently have a multi-step formula which requires a manual input for daylight savings start and end dates. Looking for recommendations of a more efficient and automated method to achieve this.

Alteryx Certified Partner
Alteryx Certified Partner

Hi @mararms ,

 

what SQL Server version are you using? If it's 2016 or 2019, the "AT TIME ZONE" feature exists -
I think, daylight saving is considered in this.

You will need two steps then:

- converting the number to a datetime2 field (DateAdd should do that)

- converting to the time zone you need (Convert with target time zone)

 

Do this help?

 

Best regards

 

Roland

Atom

Thank you, Roland. My DBA corrected the date time field at the database level so I didn't need to try your suggestion.

Labels