Can substring be used for var declared as TIMESTAMP

Sriram K · New User Joined: 17 Feb 2009 Posts: 32 Location: Bangalore

Can substring be used for a table variable declared as TIMESTAMP.

I tried the below query

* COLA is declared as TIMESTMAP *

Select SUBSTR( COLA, 1, 10)
From TABLEA
...
..

I got sqlcode -171. Can anyone suggest on this.

dbzTHEdinosauer · Posted: Sat Jun 13, 2009 3:35 pm

Suggest you cast the timestamp column with the scalar function CHAR

Raghu navaikulam · Posted: Tue Jun 16, 2009 4:03 pm

Hi

As Dick suggested, you can use the CHAR function to convert Packed Decimal Timestamp to Character format and then apply SUBSTR function.

Eg. SELECT SUBSTR(CHAR(COLA), 1,10)) FROM TABLEA;

Regards
Raghu

Sriram K · New User Joined: 17 Feb 2009 Posts: 32 Location: Bangalore

It worked.

Thanks.