Return only date from dataset.

Chriz L

11y1.2k.NET

Hello,

I have a stored procedure that populates dates in SQL Server 2012 (InsDate AS date). When I execute the spoc i get InsDate=2015-06-06 which is the format I need.

I retieve data into my webform using the following code:

SqlCommand command = new SqlCommand("SelectSproc", connection);

command.CommandType = CommandType.StoredProcedure;

SqlDataAdapter adapter = new SqlDataAdapter(command);

DataSet ds = new DataSet();

adapter.Fill(ds);

insDate.Text = ds.Tables[0].Rows[0]["InsDate"].ToString();

Result: insDate.Text= 2015-06-06 12:00:00 am

Why do I get the time part since I'm populating only dates from the SQL? How can I get rid of the time part?

Thank you in advance.

8 Replies

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

Hemlata Kushwaha11y ago
Accepted answer
Now, Try this again

insDate.Text = convert.ToDateTime(ds.Tables[0].Rows[0]["InsDate"]).ToString("dd/MM/yyyy");

Result:
-----------
06/06/2015
0
Hemlata Kushwaha11y ago
Welcome!
0
Chriz L11y ago
That works, thank you both!
0
Manas Mohapatra11y ago
Try below code:

insDate.Text = ((DateTime)ds.Tables[0].Rows[0]["InsDate"]).ToString("hh:mm:ss tt");

Make sure that value is not NULL. If you have any NULL value then before conversion you need to check NULL value.
0
Chriz L11y ago
Still getting the same error "Error 1 No overload for method 'ToString' takes 1 arguments"
0
Hemlata Kushwaha11y ago
Try this

insDate.Text = ds.Tables[0].Rows[0]["InsDate"].ToString("dd/MM/yyyy");

Result:
-----------
06/06/2015
0
Chriz L11y ago
Thank you for the quick answer.

I get overload error on .ToString("hh:mm:ss tt")
0
Manas Mohapatra11y ago
Try below code:

insDate.Text = ds.Tables[0].Rows[0]["InsDate"].ToString("hh:mm:ss tt");

Output:
-------------
12:00:00 PM
0