how to display only date from DateTime

Question

i m getting date from sql server database and it is displaying datetime as 1/15/2015 12:00:00 AM.

code in c# i used is:

dob_lbl.Text = reader[6].ToString();

//this is extracted using Sqlconnection so it's in array format.

i need only date to display.pls help.

[Custom Date and Time Format Strings](http://msdn.microsoft.com/en-us/library/8kb3ddd4%28v=vs.110%29.aspx) — danielnixon, Jan 16 '15 at 02:50

Sudhakar Tillapudi · Accepted Answer · 2015-01-19T11:57:27.123

4

try this:

string strDate = reader[6].ToString();
dob_lbl.Text  =  DateTime.ParseExact(strDate, "M/dd/yyyy hh:mm:ss tt", 
                            CultureInfo.InvariantCulture).ToString("yyyy/MM/dd");

edited Jan 19 '15 at 11:57

answered Jan 16 '15 at 02:48

Sudhakar Tillapudi

25,307
5
35
65

i tried this bro but it didn't work. ERROR: No overload for method 'ToString takes 1 arguments'. – alex dave Jan 16 '15 at 02:51
i guess you are getting the DateTime from sql server as string then check the edited answer... – Sudhakar Tillapudi Jan 16 '15 at 02:54
thank u.it worked fine. – alex dave Jan 16 '15 at 03:38
this is not displaying date like 1986-02-02 from Sql Server. not working with all values. – alex dave Jan 19 '15 at 11:22
if you want two digit month then you need to add an extra `M` in ToString() function format (`"yyyy/MM/dd"`), check my edited post. – Sudhakar Tillapudi Jan 19 '15 at 11:58

score 1 · Answer 2 · answered Jan 16 '15 at 03:02

1

The ToShortDateString method of DateTime should help with this.

Use it like:

string strDate = reader[6].ToString();
DateTime dateTime = DateTime.Parse(strDate);
string justDateStr = dateTime.ToShortDateString();

answered Jan 16 '15 at 03:02

Derek W

9,368
5
53
66

score 0 · Answer 3 · answered Jan 16 '15 at 02:57

0

You could simply split the string and use the first part of the resulting array. Something like:

dob_lbl.Text = reader[6].ToString().Split()[0];

answered Jan 16 '15 at 02:57

bit

4,271
1
27
47

how to display only date from DateTime

3 Answers3