Re: Convert

pal wrote:
> 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.

This may help you with future questions: http://www.psoug.org/reference/sqlserver.html

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org