Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a strange problem and quite simply no idea how to deal with this,
my log files contain data for every half second which provides two time formats e.g
57601.5 |
57602 |
(time#(Timestamp,'ss:f'),'hh:mm:ss:f') as Timestamp,
(time#(Timestamp,'ss'),'hh:mm:ss') as Timestamp,
I can solve each of the formatting errors seperatly using one of the above lines but cant figure out how to solve both at the same time.
I presume the script must read something like;
"if format is A do X, if NOT do y"
but the above is a little beyond me.
any help would be greatly appreciated. thanks
Time(Time#(Timestamp,'ss[.f]'),'hh:mm:ss:f') as Time
Time(Time#(Timestamp,'ss[.f]'),'hh:mm:ss:f') as Time
Brill thanks
You're welcome
regards
Marco