Re: Urgent Query

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 ???

Try this instead:

select to_char(sysdate ,'dd/mm/yyyy hh:mi:ss AM') from dual;

//Walt Received on Mon Jul 31 2006 - 08:28:30 CDT