sql select datetime stamp as m/d/y only. (without h m s)

When I select two rows with a DATETEIME stamp, I only want the m/d/y开发者_C百科 data and nothing after that.

It has to changed during the select (not afterwards).

---

To remove the time you just need to do the following Assuming SQL Server

Pre SQL 2008

select DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0) yourdate
FROM yourtable

SQL 2008

select CAST(getdate() as date) yourdate
FROM yourtable

See Most efficient way in SQL Server to get date from date+time? or

Best approach to remove time part of datetime in SQL Server

---

Is this for export? If you only want the text you can use a variety of coversion formats available on MSDN.

select convert(varchar, getdate(), 101)
-- output: 07/05/2011

Otherwise, if you're using sql 2008, you can just cast the datetime to date:

select cast(getdate() as date)