Thread: Problem with to_date/to_char
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
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/