Re: comparing datetime
- From: Jose Soares <jose.soares@xxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 17 Apr 2013 16:52:29 +0200
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@xxxxxxxxxxxxxx>wrote:
>
>> alter session set nls_timestamp_tz_format='YYYY-MM-DD HH24:MI:SS.FFTZD';
>>
>>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
