Re: comparing datetime
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: jose soares <jose.soares@xxxxxxxxxxxxxx>
- Date: Wed, 17 Apr 2013 17:13:10 +0100
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@xxxxxxxxxxxxxx>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@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
>
>
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
//www.freelists.org/webpage/oracle-l
Other related posts:
