Can anyone advise me on how could I convert the time dimension from 24-hour to 12-hour format?
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
Hai Asok Try This One
SET TimeFormat='h:mm:ss TT';
'h:mm:ss'--->24 hrs Format
h:mm:ss TT-->12 hrs Format->Time Value In--->AM/PM
Try like this
=Time(time_column, 'hh:mm:ss TT')
simply use it on script side
timestamp(time_coloumn,'hh:mm:ss TT') as Time
=Time(Your_Time_filed, 'hh:mm:ss TT')
The formats you guys stated worked, but am not getting the correct output. Have a look at the screenshot below:
Am only getting all the hours with 12 minutes in between, its not a full 24hours cycle with 1second intervals as expected. Please advise.
Its alright, found a out solution to it. Thanks!
Retrieving data ...