- Posts: 25
- Thank you received: 0
Converting 12hr Time to 24
11 years 2 weeks ago #5568
by Matt
Converting 12hr Time to 24 was created by Matt
Hello
I have 2 columns coming in, both string, one is date formatted mm/dd/yyyy, the second HH:MM AM.
I need to combine the 2 columns and convert them to date/time format mm/dd/yyyy HH24:MM.
How can I do that?
Matt
I have 2 columns coming in, both string, one is date formatted mm/dd/yyyy, the second HH:MM AM.
I need to combine the 2 columns and convert them to date/time format mm/dd/yyyy HH24:MM.
How can I do that?
Matt
Please Log in or Create an account to join the conversation.
11 years 2 weeks ago #5573
by admin
Mike
ETL Architect
Replied by admin on topic Re: Converting 12hr Time to 24
Join fields together using Joiner than use Reformat date function
Peter
Peter
Mike
ETL Architect
Please Log in or Create an account to join the conversation.