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 and date columns

Re: sysdate and date columns

From: Doug O'Leary <dkoleary_at_mediaone.net>
Date: Wed, 19 Jan 2000 18:23:13 -0600
Message-ID: <MPG.12f0116bdcd1f66a98971b@nntp.ce.mediaone.net>


Hi;

From what I understand,

select *
from <table>
where trunc(date1) = trunc(sysdate);

should work.

Doug
--



Douglas K. O'Leary
Senior System Admin
dkoleary_at_mediaone.net
Received on Wed Jan 19 2000 - 18:23:13 CST

Original text of this message

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