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

Home -> Community -> Usenet -> c.d.o.server -> sysdate without time

sysdate without time

From: Bertie Brink <bhb_at_donotspammailme.com>
Date: Thu, 27 Jul 2006 17:21:33 -0400
Message-ID: <12cic2klktuh7b4@news.supernews.com> 





What is the best way to assign sysdate to a column in a trigger with 
time component set 00:00:00?



Also how can one compare a column to sysdate in a query, while ignoring 
the time components in both?



Thanks



Bertie Brink


Life is a sexually transmitted disease.  R. D. Laing
http://www.setdefault.com/ : http://www.csmonitor.com/
Received on Thu Jul 27 2006 - 16:21:33 CDT












Original text of this message













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