Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hello
time(time#('211024', 'HHMMSS'), 'HH:MM:SS')
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?
you can do it load script:
LOAD
....
TimeField,
time(time#(Left(TimeField, 4), 'HHMM'), 'HH:MM') AS FormattedTimeField
FROM ...