Extract only Time from column

[P_Kale]

Hi,

I have a column which have date & time in 1 column. I have manage to separate date from this but how i can separate time in another column. Below given is the eg.

INTERACTIONCREATEDAT

2022-03-02 18:53:50.000

I want time i.e. 18:53 only in another column ( Not want seconds). How I achieve this.

Thanks in advance. 

[MatheusC]

@P_Kale
 
try,

Time(Interaction, 'hh:mm')
Att, Matheus

[Anil_Babu_Samineni]

I agree @MatheusC , but sometimes it must be like below due to format.

Time(TimeStamp#(Interaction), 'hh:mm') as Interaction_New

[rwunderlich · Accepted solution]

Time(Interaction, 'hh:mm')

will still include the date in the internal value. That may make for peculiar sorting. Iff you want just the time portion, I would recommend 

Time(Frac(Interaction), 'hh:mm')

-Rob

[P_Kale]

Thanks for help.

[P_Kale]

Thanks for help