i want to extract the date alone from the sqlserver using ASP

Why do you need the date from SQL server? You can get the date in ASP with Date() or Now(). Date will give you the short date and Now will give you long date.

For MS-SQL :

SELECT getDate()

I am assuming you are reading a datetime from sql server, and you are interested in the date portion, and want to ignore the time portion.

There are several ways to do this, here is one:
- Let's assume you are reading the value from a recordset named rs with a field named "MyDate"
reposne.write Int(rs("MyDate"))))






Woody Z http://www.learntoprogramnow.com