fetch date from date and time field

Question

2015-04-20 15:32:26.840 is the record in sql table field..how can i fetch only date from the table.

Govinda Rajulu Yemineni · Answer

Hi Sushma Sharma, Below approach works in Sql Server 2008 and above: SELECT CONVERT ( DATE , Column_Name) 'Date Part Only' FROM Table_Name RESULT: Date Part Only -------------- 2013-07-14 Below approaches works in all the versions of Sql server Example 1: SELECT CONVERT ( VARCHAR (10), column_name, 112) 'Date Part Only' FROM Table_Name RESULT: Date Part Only -------------- 20130714 Example 2: SELECT CONVERT ( VARCHAR (10), column_name, 111) 'Date Part Only' FROM Table_Name RESULT: Date Part Only -------------- 2013/07/14

sushma sharma · Answer

thanks a lot..

Manoj Bhoir · Answer

Hi, In RDL you can change format of DateTime column. Right Click on Date Time Column Select Expression In that window Write like this : =Format(Field!DateColumn.Value, "dd/MM/yyyy")

sushma sharma · Answer

its working fine in store procedure in sql but when i am linking this store procedure with RDL file its showing the full datetime field..what should i do??

Manoj Bhoir · Answer

Hi, Try this : Select * From TableName Where Cast(Column Name As Date) BETWEEN '2015-04-01' And '2015-04-31' I hope this will help you.

Nilesh Jadav · Answer

hey there ! Check this source: http://sqlfiddle.com/#!3/1fa93/1 http://www.sqlservercentral.com/Forums/Topic815810-145-1.aspx http://www.aspdotnet-suresh.com/2012/08/query-to-get-data-between-two-dates-in.html Hope that helps thank you

sushma sharma · Answer

hi, thnks but i hve tried this approach..and its not fulfilling my need..

sushma sharma · Answer

hi manoj, it is fetching the date part but how i apply condition in it to get date between two dates..

Manoj Bhoir · Answer

Hi, Try Select Cast(Column Name As Date) From TableName See this sample : Select CAST('2015-04-20 15:32:26.840' AS DATE) Output : 2015-04-20

Ankit Shukla · Answer

Hello, Are you asking in C#.Net? If yes: suppose select date and saved in a string 's', then: string s = cmd.Parameters["@StartDate"].Value.ToString(); DateTime dtr = Convert.ToDateTime(s, new CultureInfo("en-GB")); TextDate.Text = dtr.ToString(); Kindly use using System.Globalization; namespace. Good luck..

fetch date from date and time field

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (10)