I have been working on a project at work and I discovered the following works for retrieving dates from SQL Server:
SELECT * FROM view_Employees_Awards WHERE stringDate BETWEEN '2005-06-01' AND
'2005-07-01' ORDER BY Awarded_Date DESC
The following brings back every date from the beginning of 2005-06-01 00:00:00
To
2005-06-01 23:59:59
Subscribe to:
Post Comments (Atom)
-
How to clear SharePoint People Picker suggestion cache If you have been SharePoint Site owner long enough, you would have definitely ...
-
Getting the following error (Figure 1): Server Error in '/' Application. ID4014: A SecurityTokenHandler is not registered to ... -
The problem was that the remote connection needed to utilize Named Pipes, but in order to utilize Named Pipes both the machine hosting the i...
No comments:
Post a Comment