How can convert a string into a timestamp (hh:mm)?
1531 into 15:31
0805 into 08:05
This code doesn't seem to work:
Time(Time#([String], 'hh:mm') ) AS [StringHour],
After that, how would I combine it with a date to create a date/time column?
Thanks in advance
Time(Time#([String], 'hhmm') ,'hh:mm') AS [StringHour],
View solution in original post
for the second part something like this
timestamp(timestamp#(date_field & [StringHour],'DD/MM/YYYYhh:mm')) as date_time
here DD/MM/YYYY I have assumed as date format.
For second part, this is also possible
TimeStamp(DateField + Time(Time#([String], 'hhmm') ,'hh:mm')) as date_time_field