wants to validate and save dates in sql

Hi
For the second question

No, there is no "date" data type in sql server 2005, but introduced in SqlServer 2008.

When you store try to save Date part of DateTime..

you do not want the time (hh:mm:ss) portion from the query then use convert function

---- Retrieve info from table and return date (datatype) value
-----as character mm/dd/yyyy

select CONVERT(varchar(10),DateTimeColumnName,101) as MyDate
from TableName

OR

select CONVERT(varchar(10),GETDATE(),101) as charSystemDate

Validate date (datatype with T-SQL)

For Instance T-SQL via Store procedure
---------- Begin of Proc----------------------
CREATE PROC uspStoreData
@dtDate varchar(50)
as

DECLARE @dtRealDate datetime

IF ISDATE(@dtDate)=1
BEGIN
SET @dtRealDate = CONVERT(datetime,@dtDate)
END

----- Insert into tableName (DateTimeColumnName) values(@dtRealDate)
OR
---- update tableName set DateTimeColumnName=@dtRealDate where clause here

---------- End of Proc----------------------

-----------------------------------------------------
With ASP.NET, C#, VB.NET:
-----------------------------------------------------
if you need a good tools to validate input from a form then
download the free tools that a friend of mine put together that works
with ASP.NET, C#, VB.NET (Windows form and Web Forms
http://www.netstair.com/download/ncTools/ncTools-Lib.zip

---- Convert to Date/Time yyyy-mm-dd hh:mm:ss (Once downloaded use as follow)
ncTools.oUtilities oObj = new ncTools.oUtilities()
DateTime dtDateInputed
if (oObj.IsDate(textbox1.text))
{
dtDateInputed = Convert.DateTime(textbox1.text);
}
----- Convert to String mm/dd/yyyy
string strDateInputed = Convert.DateTime(textbox1.text).ToShortDateString();



Good Luck
Al