Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i am trying to display a time field properly as a dimension, my data for this field is in the following format..
093025
which is the correct format but its missing the colons (09:30:25)
How do i insert the colons? i have tried but all i am getting is 00:00:00..
Thanks
left(fieldname,2)&':'&mid(fieldname,3,2)&':'&right(fieldname,2) as Newfield name in script
or you can use in expression also
Hi,
Use time stamp function
Rgds
Anand
left(fieldname,2)&':'&mid(fieldname,3,2)&':'&right(fieldname,2) as Newfield name in script
or you can use in expression also
TimeStamp function returns 00:00:00
Thanks Sunil, i have used your suggestion in an expression.
Hi,
See how the time stamp is used by below example
Raw:
load * inline
[
COl
093025
];
Data:
Load
left(COl,2) as HH,
mid(COl,3,2) as MM,
Right(COl,2) as SS,
Timestamp#((left(COl,2) &':'& mid(COl,3,2) &':'& Right(COl,2) ),'HH:MM:SS') as a
Resident Raw;
See the sample file
Rgds
Anand
Hi,
Can you check it my way hope you got it if so mark it correct or helpful answer.
Rgds
Anand