Database

declare @a nvarchar(20)
set @a = '30/11/2009'
select isdate(@a)
-- returns 1
set @a = '31/11/2009'
select isdate(@a)
-- returns 0

Lalit singh wrote:

Is there any way to store into sql server 2005 date column with date only excluding time.

SELECT o1.OrderID, o1.CustomerID, o1.EmployeeID, o1.OrderDate, o1.RequiredDate
FROM Orders AS o1
WHERE o1.OrderDate = (SELECT MAX(o2.OrderDate)
		      FROM Orders AS o2
	       	      WHERE o2.EmployeeID = o1.EmployeeID) 
AND o1.RequiredDate = (SELECT MAX(o3.RequiredDate)
                       FROM Orders AS o3
                       WHERE o3.EmployeeID = o1.EmployeeID
                            AND o3.OrderDate = o1.OrderDate)
AND o1.OrderId = (SELECT MAX(o4.OrderID) 
                  FROM Orders AS o4
                  WHERE o4.EmployeeID = o1.EmployeeID
                  AND o4.OrderDate = o1.OrderDate)