"Round" timestamp på hundreds of a second

[#1]

Hi,

trying to show the time (extracted from a timestamp) with hundreds of a second as per below:

2014-08-01 09:34:38.172512 should be 09:34:38:17

I tried the below but the 'hundreds' are not showing correct.

Text(Time(round(Timestamp, (1/8640000)), 'hh:mm:ss:HH')) as Time

Any clues?

Regards,

Olle

[Anonymous · Accepted solution]

instead of 'hh:mm:ss:HH' use 'hh:mm:ss:ff'

[#3]

hi

try this

=date(date#('2014-08-01 09:34:38.172512','YYYY-MM-DD hh:mm:ss.ffffff'),'YYYY-MM-DD hh:mm:ss.ff')

or try this

=date(date#('2014-08-01 09:34:38.172512','YYYY-MM-DD hh:mm:ss.ffffff'),'hh:mm:ss.ff')

[MarcoWedel]

Time(Round(Frac(Timestamp),1/8640000),'hh:mm:ss:ff') as Time

to also extract the time part from the timestamp, also round the numeric value to 1/100 sec and not only change the textual representation

[PrashantSangle]

Hi,

Use Time(Fieldname,'hh:mm:ss.ff') Regards

[#6]

Great, thanks!

[ashfaq_haseeb]

Try this

=time(Timestamp#(Timestamp,'yyyy-mm-dd hh:mm:ss.fffff'),'hh:mm:ss.ff') as Time

Regards

ASHFAQ