fetch date from date and time field

sushma sharma

11y1k

2015-04-20 15:32:26.840

is the record in sql table field..how can i fetch only date from the table.

10 Replies

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

Govinda Rajulu Yemineni11y ago
Accepted 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 sharma11y ago
thanks a lot..
Manoj Bhoir11y ago
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 sharma11y ago
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 Bhoir11y ago
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 Jadav11y ago
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 sharma11y ago
hi,
thnks but i hve tried this approach..and its not fulfilling my need..
sushma sharma11y ago
hi manoj,
it is fetching the date part but how i apply condition in it to get date between two dates..
Manoj Bhoir11y ago
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 Shukla11y ago
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..