Convert

 SELECT CONVERT(Char(4), location.next_pay_date, 102)  INTO :is_year
 FROM location
 WHERE location.loc_cd = '01' ;

This code works properly with SQLServer,

how to do the convert(Char,location.next_pay_date, 102) in oracle..

can any one help me out. Received on Tue Nov 20 2007 - 06:31:36 CST