how to get the date alone from date/time from sql server

Question

how do i get the date alone from datetime field from sql server. eg 2015-01-29 10:17:37.000 from this i want only the date 2015-01-29

Ghanshyam Baravaliya · Answer

hi try this SELECT CAST(GETDATE() AS DATE)

Michal Habalcik · Answer

hi, these should work. replace the getdate() with your column name SELECT CONVERT(date, getdate()) SELECT CAST(getdate() as date)

Sumit Joshi · Answer

Use Convert.ToShortDateString(FETCHED DATE); in your code it will only give you date not timestamp Accept my answer if its helpful. Thanks

Upendra Pratap Shahi · Answer

Hello , Use this- select CONVERT ( VARCHAR ( 10 ), GETDATE (), 110 );

Rajeesh Menoth · Answer

Hi, CONVERT(VARCHAR(10),GETDATE(),110) output : 11-04-2014 Ref this : http://www.w3schools.com/sql/func_convert.asp http://sqlhints.com/2013/07/14/how-to-get-date-part-only-from-datetime-in-sql-server/

Jignesh Trivedi · Answer

hi, you can casting this datetime field to date if you are using SQL server 2008 and above . try... select CAST('2015-01-29 10:17:37.000' as date) select CAST(yourdatetimefiled as date) from table1 hope this will help you.

santhosh kumar · Answer

Thanks Suraj, but i need the same in sql Server Query can u help it out

Suraj Sahoo · Answer

Hello Santosh, If you are not having the data type for the column as only "date" and the datatype is "datetime", then you will be saving the datetime object in the column. And anticipating you have c# used. C# only has DateTime class. Even if you fetch date or datetime object c# understand datetime only. So you can have a viewmodel having the date property as string in C# and while retrieving and setting the value from SQL server, Use Convert.ToDateTime(FETCHED DATE).ToShortDateString(); The ToShortDateString() returns only a date. I hope this helps Thanks

how to get the date alone from date/time from sql server

Answers (8)