Time Stamp to Time

[#1]

Good Day i have Problem with this TimeStamp that i would like it to converted into time.

Sample:

2012-10-16 09:21:01 the output must be 9:21

But in time

time(left(right(time,8),5),'HH:MM') as Time output is 00:12?

can somebody give me idea?

Thank you,

[Oleg_Troyansky]

first, you need to convert your string to a timestamp, and then format it any way you want. The syntax should be something like this:

timestamp( 

       timestamp#(MyTime, 'YYYY-MM-DD hh:mm:ss')

, 'hh:mm')

notice that the hours, minutes and seconds are represented by the lower case letters : hh:mm:ss, in contrast to YYYY-MM-DD

cheers,

Oleg Troyansky

[#3]

timestamp(timestamp#(timelogs, 'YYYY-MM-DD hh:mm:ss'),'hh:mm') as Time no Output
and i tried this one
time(timestamp#(timelogs, 'YYYY-MM-DD hh:mm:ss'),'hh:mm') as Time no Output too.

Thank you for your Response

[#4 · Accepted solution]

U can use the below expression.

=timestamp(Timestamp('2012-10-16 09:21:01', 'YYYY--MM-DD HH:MM:SS'),'h:mm')

~Kabilan K.

[#5]

Got it Thank you.

[praveenak]

Hi,

I think u can use the below exp.

=time('2012-10-16 09:21:01','h:mm')

[Koniki]

=time('2019-07-28 09:21:01','h:mm')