Need to understand this query

shreevamsi · Posted: Tue Nov 27, 2007 12:51 pm Post subject: Need to understand this query

Hi,
Could anyone let me know what is ISO in

SELECT * FROM XXX.BBB
WHERE
POL_NO = 1234 AND
SUBSTR(CHAR(ST_DATE,ISO),1,4) = 2001;

I haven't come across SUBSTR function in the above format but it is in production. What does it do??

Thanks,
~Vamsi

guptae · Posted: Tue Nov 27, 2007 12:55 pm Post subject:

Hi Vamsi,

Please refer the below link

http://www.ibm.com/developerworks/db2/library/techarticle/0211yip/0211yip3.html

shreevamsi

Thanks Ekta,
It was very helpful.

guptae · Posted: Tue Nov 27, 2007 2:15 pm Post subject:

Welcome Srivasmi