Re: comparing datetime

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: jose soares <jose.soares@xxxxxxxxxxxxxx>
  • Date: Wed, 17 Apr 2013 10:16:43 -0400

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


Other related posts: