SQL Server 2008 select date only from field

Question

I have a table with dates & times in columns.

I need to select the date portion only from a column named last_date.

I see all the information on selecting, but they do not include a column name.

Could someone point out how to select the date portion from a field in a table using the column name??

Thank you

Provide us more information: table structure, data sample, what you've tested,... — Joël Salamin, Sep 17 '14 at 20:37
To select just the date part try `CONVERT(DATE, last_date,101)`. — user2989408, Sep 17 '14 at 20:38

score 1 · Accepted Answer · answered Sep 17 '14 at 20:43

1

SELECT CAST( last_date as DATE) from TableA

answered Sep 17 '14 at 20:43

radar

1 Answers1