Re: Urgent Query

Thanks for the response

I have done it using

select to_date(CURRENT_DATE,'dd/mm/rrrr hh:mi:ss AM') from dual;

Thanks,

Deepa
sybrandb wrote:
> deepagulati_at_rediffmail.com wrote:
> > Hi,
> > This query
> > select to_date(CURRENT_DATE,'dd/mm/yyyy hh:mi:ss AM') from dual;
> >
> > returnig the result as 31/07/0006 while the current year is 2006 ???
> >
> > plz help
>
> Are you by any change converting a date column to a date?
> Shouldn't it just be TO_CHAR(current_date.....
>
> Just asking
>
>
> As this is a volunteer forum, there is no such thing as 'urgent'.
> If it is urgent, call support.
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Mon Jul 31 2006 - 08:25:39 CDT