Help with formatting Time

[hopkinsc]

Hi,

I have a Dimension set up for 'Transaction Time'. I would like to change the format in which the time is displayed. It currently shows as 211024 which is basically 9:10pm and 24secs but i want it to display as 21:10.

Can anyone help?

[sparur]

Hello

time(time#('211024', 'HHMMSS'), 'HH:MM:SS')

[hopkinsc]

Thanks for your answer, thats not exactly what i wanted though. i have several thousand different transactions at different times, i want the format for every transaction time to be displayed as HH:MM. at the moment they are all displayed as hhmmss.

Any ideas?

[sparur]

you can do it load script:

LOAD

....

TimeField,

time(time#(Left(TimeField, 4), 'HHMM'), 'HH:MM') AS FormattedTimeField

FROM ...