Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SYSDATE VS SYSTIMESTAMP

Re: SYSDATE VS SYSTIMESTAMP

From: <setsun_at_gmail.com>
Date: 4 Apr 2006 07:51:16 -0700
Message-ID: <1144162276.516995.128530@v46g2000cwv.googlegroups.com>


Vlad,

Thanks for your response.

What if my LAST_MOD_DATE of a TRADE_ID is 2 days prior to systimestamp? My query with systimestamp-5 would 'sometimes' not pick up those records. Received on Tue Apr 04 2006 - 09:51:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US