Thread: Problem with to_date/to_char

Problem with to_date/to_char

From
"Amin Schoeib"
Date:

Hi,
Can somebody tell me why this query don't work when I use to_date
Instead of to_char

By using to_char:

select
 to_char(last_day(cast(current_date - interval '1 month' as date)),'DD.MM.YYYY')
 ;

Result:  31.08.2003

By using to_date:

select
 to_date(last_day(cast(current_date - interval '1 month' as date)),'DD.MM.YYYY')
 ;

Result:  01.23.0037

What can I do that this query works correctly with to_date?

Thanxx

Schoeib

4Tek Gesellschaft für angewandte Informationstechnologien mbH
Schoeib Amin
Tel.  +49 (0) 69 697688-132
Fax. +49 (0) 69 697688-111
http://www.4tek.de

Re: Problem with to_date/to_char

From
Karel Zak
Date:
On Fri, Sep 05, 2003 at 11:26:05AM +0200, Amin Schoeib wrote:
> Hi,
> Can somebody tell me why this query don't work when I use to_date
> Instead of to_char
>
> By using to_char:
>
> select
>  to_char(last_day(cast(current_date - interval '1 month' as date)),'DD.MM.YYYY')
>  ;
>
> Result:  31.08.2003
>
> By using to_date:
>
> select
>  to_date(last_day(cast(current_date - interval '1 month' as date)),'DD.MM.YYYY')
>  ;

 to_date() do conversion from 'string' to 'data' .... see docs.

    Karel

--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/