Time format.

[#1]

Hi folks,

Can anyone advise me on how could I convert the time dimension from 24-hour to 12-hour format?

Sample script:

Time_DIM:

Load

     time(frac(time_column),'HH12:MM:SS AM/PM');

     @or

     time(frac(time_column),'HH12:MM:SS');

From Time_DIM.xls;

Thanks.

Best Regards,

R

[brijesh1991]

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

[arjunkrishnan · Accepted solution]

Hai Asok Try This One

SET TimeFormat='h:mm:ss TT';

time(frac(time_column),'$(TimeFormat)');

'h:mm:ss'--->24 hrs Format

h:mm:ss TT-->12 hrs Format->Time Value In--->AM/PM

[jagan]

Hi,

Try like this

=Time(time_column, 'hh:mm:ss TT')

Regards,

Jagan.

[er_mohit]

simply use it on script side

timestamp(time_coloumn,'hh:mm:ss TT') as Time

[amit_saini]

Hi Ram,

Try this:

=Time(Your_Time_filed, 'hh:mm:ss TT')

Thanks,
AS

[#7]

Hi guys,

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.

Thanks.

Best Regards,

R

[#8]

Hi guys,

Its alright, found a out solution to it. Thanks!

Best Regards,

R