Re: comparing datetime

From: rjamya <rjamya_at_gmail.com>
Date: Wed, 17 Apr 2013 10:16:43 -0400
Message-ID: <CAGurbTOGQZK_qXwJ0W_DH3Xjgx+WM8V+b-+ZaS+L33-CGNWbBw_at_mail.gmail.com>

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

Received on Wed Apr 17 2013 - 16:16:43 CEST