Re: Convert

From: gazzag <gareth_at_jamms.org>
Date: Tue, 20 Nov 2007 04:54:02 -0800 (PST)
Message-ID: <2972c705-b76d-4938-a0d2-f5b98566bcbd@w34g2000hsg.googlegroups.com>

On 20 Nov, 12:31, pal <jayadevpal..._at_gmail.com> 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.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions180.htm#i1009324

HTH -g Received on Tue Nov 20 2007 - 06:54:02 CST