Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date comparision

Status
Not open for further replies.

crsdev

Programmer
Sep 29, 2006
96
US
Hello ALL,
Disregarding the time how can i compare the date.
i.e.
select * from sometable
where somedate = sysdate.

Thanks in advance
 
Code:
select * from sometable 
where trunc(somedate) = trunc(sysdate);


[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top