dagga007
asked on
Select all records for one day.
I looking to return only records you the current date with out any user input
Access has a DATE() function. Not sure what to use in SQL
Access has a DATE() function. Not sure what to use in SQL
sql server is getdate()
You can use GETDATE () instead of DATE()
ASKER
Should the getdate() return all records for todays date?
No, getdate stores the current date + current time
SELECT CONVERT(varchar(10),GETDAT E(),101) -- mm/dd/yyyy
SELECT CONVERT(varchar(10),GETDAT E(),103) -- dd/mm/yyyy
SELECT CONVERT(varchar(10),GETDAT
SELECT CONVERT(varchar(10),GETDAT
ASKER
Not sure i follow, I think that i'm on the wrong track.
I'm looking to return all record for one day with out any user input.
I'm looking to return all record for one day with out any user input.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Select * From YourTable Where Convert(Varchar, DateColumn, 101) = Convert(Varchar, GetDate(), 101)
Imran
Imran