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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Function: Time stamps for today

Status
Not open for further replies.

joeb007

MIS
Apr 5, 2012
4
US
Hello all trying to query all of the time stamps that ocurred today only.

was trying to use:

Select
""
""
having system_info.date_time)>=Date()+1 And (system_info.date_time)<Date()+2)

as well

(system_info.date_time = DATEADD(dd,1,GETDATE()) and GETDATE())

but no luck

was is the correct syntax to query from a select statment all the time stamps that happend today only....

Thanks SO MUCH...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top