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 -> Re: getting records for 1 day

Re: getting records for 1 day

From: Paul Lautman <paul.lautman_at_btinternet.com>
Date: Sun, 4 Nov 2007 12:08:01 -0000
Message-ID: <5p5r0uFpgjp6U1@mid.individual.net> 





Summercool wrote:


> in SQL, i wonder if I do a

>

>

>  select * from tablefoo where add_date = "2007-11-01"

>

>

> then it may not show any record as it will only match recorded added

> exactly at 2007-11-01 00:00:00



Only if add_date is a DATETIME or TIMESTAMP type of field as oposed to a 
DATE type.
Received on Sun Nov 04 2007 - 06:08:01 CST












Original text of this message













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