I have a time column in the attached file. I would love to break it down to hour, minutes and seconds
hour ('09:14:36 AM')
Minute ('09:14:36 AM')
View solution in original post
Try like this .
Timestamp(Time , 'hh') as Hours,Timestamp(Time , 'mm') as Mins,Timestamp(Time , 'ss') as Seconds