Decimal to DateTime
My data for date is being imported as decimals in a text format. How do I convert this 43497.241179 to date time? Using magic ETL or beastmode.
0
Comments
-
Something like this should get you started, where you replace the number with your value column.
addtime(
str_to_date(DATE_ADD('01-JAN-1900', INTERVAL 43497.2411 day),'%Y-%d-%m')
,mod(43497.2411,1)*24*60*60
)For time you may need to adjust for some Leap Day issues as discussed in the comments here.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- 7.3K All Categories
- 13 Getting Started in the Community
- 141 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 902 Connectors
- 236 Workbench
- 342 APIs
- 77 Apps
- 19 Governance & Productivity
- 234 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 572 日本支部