|
View previous topic :: View next topic
|
| Author |
Message |
shreevamsi
Active User
Joined: 23 Feb 2006
Posts: 305
Location: Hyderabad,India
|
|
|
|
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 |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
| Back to top |
|
|
shreevamsi
Active User
Joined: 23 Feb 2006
Posts: 305
Location: Hyderabad,India
|
|
|
|
Thanks Ekta,
It was very helpful. |
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
| Welcome Srivasmi |
|
| Back to top |
|
|
|
|
