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!

Register Log in
  • Congratulations strongm 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

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
 
Sort by date Sort by votes
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]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
2K
carp
carp
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
343
SkipVought
S
EM1107
  • Locked
  • Question
Insert date and time using UTC time in a DATE column
Replies
14
Views
608
EM1107
EM1107
kernal
  • Locked
  • Question
If Day of the Week='Y' (i.e. Mon='Y') and between a Start Date and End Date then Count #of Days 1
Replies
1
Views
103
Beilstwh
Beilstwh
kernal
  • Locked
  • Question
Change DATE and also a TIMESTAMP to just a date as 'MM/DD/YYYY. Also, need dummy date when null 1
Replies
2
Views
90
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top