Query on time function

[hopkinsc]

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

[its_anandrjs]

Hi,

Use time stamp function

Rgds

Anand

[SunilChauhan · Accepted solution]

left(fieldname,2)&':'&mid(fieldname,3,2)&':'&right(fieldname,2) as Newfield name in script

or you can use in expression also

[hopkinsc]

TimeStamp function returns 00:00:00

Thanks Sunil, i have used your suggestion in an expression.

[its_anandrjs]

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

[its_anandrjs]

Hi,

Can you check it my way hope you got it if so mark it correct or helpful answer.

Rgds

Anand