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

Search results for query: *

  • Users: MANU
  • Order by date
  1. MANU

    To get date part only in SQL out of datetime field stored as getdate()

    I am trying to run the query : SELECT Payment_Date FROM dbo.tbl_PaymentDt WHERE Payment_Date BETWEEN '08/06/2002' AND '08/07/2002' In the table, Payment_Date is stored as default value getdate(). The above query results in the records for '08/06/2002' only, even if the records are present...

Part and Inventory Search

Back
Top