Forum Discussion
Solved
Text to time format
Hi Team, I know there are many examples out there to look though but my example is not the same in terms of converting time which is in text data type to 24 hours time data type. Please see screenshot below. Any help would be appriciated.
In your query, replace "." with "" and then convert to type Time. This will show as am/pm, but you can load the data and then change the time format to 24-hour time.
Pat
1 Reply
In your query, replace "." with "" and then convert to type Time. This will show as am/pm, but you can load the data and then change the time format to 24-hour time.
Pat