Re: Playing With Truncate and Date

From: Frank van Bortel <fbortel_at_home.nl>
Date: Sat, 07 May 2011 13:07:05 +0200
Message-ID: <2f6fa$4dc527da$524b97d2$29695_at_cache4.tilbu1.nb.home.nl>



On 03/06/2011 03:43 PM, Maxim Demenko wrote:
> On 06.03.2011 15:04, John Hurley wrote:
>> Michel:
>>
>> # SQL> SELECT TRUNC( TO_DATE('27-FEB-2011') -1,'DAY')+1 FROM DUAL;
>>
>> ....ERROR at line 1: ORA-01858: a non-numeric character was found where
>> a numeric was expected
>>
>> Works for me ...
>>
>
> It is just the question of time, till somebody changes nls environment
> (it might be yourself).
>
> What Michel implied (i suppose) to tell
> 1) it is bad to rely on implicit conversion, if you can avoid it

I do not agree with the second part of that sentence.

It Is Bad(tm) to rely on implicit conversions.

-- 

Regards,

Frank van Bortel
Received on Sat May 07 2011 - 06:07:05 CDT

Original text of this message