Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |