Re: Strange (?) behaviour with SYSTIMESTAMP
- From: Steve Baldwin <stbaldwin@xxxxxxxxxxxxxxxx>
- To: pjhoraclel@xxxxxxxxx
- Date: Wed, 27 Oct 2010 06:59:41 +1100
Does this strike anyone as weird ?
SQL> select sessiontimezone from dual;
SESSIONTIMEZONE
--------------------------------------------------------------------------------
+11:00
SQL> select systimestamp - cast(systimestamp as timestamp) from dual;
SYSTIMESTAMP-CAST(SYSTIMESTAMPASTIMESTAMP)
---------------------------------------------------------------------------
+000000000 00:00:00.000000
SQL> alter session set time_zone = '+10:00';
Session altered.
SQL> select systimestamp - cast(systimestamp as timestamp) from dual;
SYSTIMESTAMP-CAST(SYSTIMESTAMPASTIMESTAMP)
---------------------------------------------------------------------------
-000000000 01:00:00.000000
Steve
On Tue, Oct 26, 2010 at 9:44 PM, Peter Hitchman <pjhoraclel@xxxxxxxxx> wrote:
> Hi,
> What about using localtimestamp instead?
>
> Regards
> Pete
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
---------------------------------------------------------------------------------------
This email is intended solely for the use of the addressee and may
contain information that is confidential, proprietary, or both.
If you receive this email in error please immediately notify the
sender and delete the email.
---------------------------------------------------------------------------------------
--
//www.freelists.org/webpage/oracle-l
Other related posts:
