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

santhosh kumar

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

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sumit Joshi11y ago
Use

Convert.ToShortDateString(FETCHED DATE);

in your code it will only give you date not timestamp

Accept my answer if its helpful.

Thanks
0
Upendra Pratap Shahi11y ago
Hello ,

Use this-

select CONVERT(VARCHAR(10),GETDATE(),110);

0
Rajeesh Menoth11y ago
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/
0
Ghanshyam Baravaliya11y ago
hi try this

SELECT CAST(GETDATE() AS DATE)
0
Jignesh Trivedi11y ago
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.
0
Michal Habalcik11y ago
hi, these should work. replace the getdate() with your column name

SELECT CONVERT(date, getdate())
SELECT CAST(getdate() as date)
+1
santhosh kumar11y ago
Thanks Suraj, but i need the same in sql Server Query can u help it out
0
Suraj Sahoo11y ago
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
0