Re: comparing datetime

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 17 Apr 2013 17:13:10 +0100
Message-ID: <CABe10sbHFX9CbspkRObpoBjhTN=4wFq=AioXwJqpx4YdcAOcrA_at_mail.gmail.com>

Do any of the issues discussed in
http://jonathanlewis.wordpress.com/2013/04/16/systimestamp/ or more pertinently perhaps the MOS notes Jonathan links to apply?

On Wed, Apr 17, 2013 at 3:52 PM, Jose Soares <jose.soares_at_sferacarta.com>wrote:

> 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-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 17 2013 - 18:13:10 CEST