Re: comparing datetime
From: Jose Soares <jose.soares_at_sferacarta.com>
Date: Wed, 17 Apr 2013 16:52:29 +0200
Message-ID: <516EB72D.7010307_at_sferacarta.com>
Hi Raj,
Date: Wed, 17 Apr 2013 16:52:29 +0200
Message-ID: <516EB72D.7010307_at_sferacarta.com>
Hi Raj,
I tried using alter session set nls_timestamp_tz_format='YYYY-MM-DD
HH24:MI:SS.FF6TZD';
but the result is the same.
j
On 04/17/2013 04:16 PM, rjamya wrote:
> Any specific reason you are comparing only centi-seconds instead of full
> resolution of FF6 ? Perhaps this will help
> alter session set nls_timestamp_tz_format='YYYY-MM-DD HH24:MI:SS.FF6TZD';
>
> Raj
>
> On Wed, Apr 17, 2013 at 8:59 AM, Jose Soares <jose.soares_at_sferacarta.com>wrote:
>
>> alter session set nls_timestamp_tz_format='YYYY-MM-DD HH24:MI:SS.FFTZD';
>>
>>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 17 2013 - 16:52:29 CEST