ASP.Net C# sqlDr.GetValue(a) Date Column Displaying Time too

Question

I tried to use

 sqlDr.GetValue(a).ToString()

to display a DATE column from my database which looks like this..(the Date Submitted column)

But the problem is , when i display it using getValue(8).toString(), something like this is displayed..

Thanks for taking your time to read my post , any reply is much appreciated!

change it to sqlDr.GetValue(a).ToString("yyyy-MM-dd") this should fix it. — iSR5
– iSR5, Commented Mar 2, 2018 at 20:20
The problem is i have many columns and not just date, does other column works too if i do that? Thanks — Aaron Lee Herng Yue
– Aaron Lee Herng Yue, Commented Mar 2, 2018 at 20:35
it works on DateTime columns only. so if the other columns matches the same datatype, it should works fine, the following link should give you a good overview learn.microsoft.com/en-us/dotnet/standard/base-types/… — iSR5
– iSR5, Commented Mar 2, 2018 at 20:38
@iSR5 Thanks, but i am getting another error after adding the line , (no overload for method 'ToString' Takes 1 arguments) Any Clue ? — Aaron Lee Herng Yue
– Aaron Lee Herng Yue, Commented Mar 2, 2018 at 20:43
perhaps your calling a nullable DateTime, review this post stackoverflow.com/questions/33371527/… — iSR5
– iSR5, Commented Mar 2, 2018 at 20:50

Joel Coehoorn · Accepted Answer · 2018-03-19 14:15:38Z

1

The problem is .Net does not have a Date-only primitive type. Therefore the Sql Server Date column type maps to a full DateTime value in .Net, which always includes a time component. If you don't provide a time component, the DateTime struct will have a 0-value time component, which maps to 12:00:00.000 AM.

To get around this, you need to specify the output format for your column, so that it explicitly does not include a time value. You want something like this:

 ((DateTime)getValue(8)).ToString("d")

However, the exact code you need will vary wildly depending on how your result table is created. If necessary, check the SqlDataReader.GetDataTypeName() function to know what type you're dealing with.

edited Mar 19, 2018 at 14:15

answered Mar 2, 2018 at 20:21

Joel Coehoorn

418k114 gold badges582 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Aaron Lee Herng Yue Over a year ago

but the problem is now i am currently displaying from dynamic table , as i would not know which value is date , my code is something like this currently. html += "<tr>"; for (int a = 0; a< (list.Count - 1); a++) { html += "<td>" + sqlDr.GetValue(a).ToString() + "</td>"; } html += "</tr>"; Thanks

Joel Coehoorn Over a year ago

Try using the SqlDataReader.GetDataTypeName() method to check the type so you can format it.

IrishChieftain · Accepted Answer · 2018-03-02 20:17:42Z

0

Try using the DateTime.ToShortTimeString Method ():

Console.WriteLine("Short date string:  \"{0}\"\n", myDateTime.ToShortDateString());

Output: Short date string: "5/16/2001"

answered Mar 2, 2018 at 20:17

IrishChieftain

15.2k8 gold badges55 silver badges98 bronze badges

Collectives™ on Stack Overflow

ASP.Net C# sqlDr.GetValue(a) Date Column Displaying Time too

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related