Getting a datetime variable from a database using dataTableReader

Question

So i have a database and i am getting from it it's data by dataTableReader.

I think when you get them from the database you get them as an object, not sure, but for sure it's not the variable i set them to be in the database.

so fur I have used only int and varchar in the database so i have converted them by using toString() and int.parse(). now i need to use a datetime variable.

How can i get it from the database as a datetime or convert it to datetime and not as string(using toString())? Thanks for the Help

1.in which format you are storing the Datetime in database? 2.does it also include time? — Sudhakar Tillapudi
– Sudhakar Tillapudi, Commented Mar 30, 2014 at 16:44
format datetime, it does include time but it's not important so much, i can take it off the time and leave the date only if you have a solution — Cooper
– Cooper, Commented Mar 30, 2014 at 16:47

rory.ap · Accepted Answer · 2014-03-30 16:48:30Z

3

Try Convert.ToDateTime(myDataReader[i]) where i is the index of your column.

answered Mar 30, 2014 at 16:48

rory.ap

35.7k15 gold badges104 silver badges199 bronze badges

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

1 Comment

Cooper Over a year ago

Thank you very much, but DateTime.parse("String") did it

Amit Joki · Accepted Answer · 2014-03-30 16:44:25Z

2

This should do in most cases:

var datetime = DateTime.Parse("string");

The string being the string saved in the database

answered Mar 30, 2014 at 16:44

Amit Joki

59.4k7 gold badges80 silver badges96 bronze badges

1 Comment

Amit Joki Over a year ago

@SonerGönül when a string is stored in a database it stores in usual format right? correct me if i am wrong

Sudhakar Tillapudi · Accepted Answer · 2014-03-30 16:48:21Z

2

How can i get it from the database as a datetime or convert it to datetime and not as string(using toString())?

Solution 1: if you are storing the Date value as DateTime type then you can directly convert into DateTime using Convert.ToDateTime() method

Try This:

DataReader dr = new DataReader();
DateTime dt;
while(dr.Read())
{
dt = Convert.ToDateTime(dr["DateColumn"]);
}

Solution 2: If you are storing the Date in some fixed format like dd-MM-yyyy as VARCHAR then you can use DateTime.ParseExact() method

Try This:

DataReader dr = new DataReader();
DateTime dt;
while(dr.Read())
{
dt = DateTime.ParseExact(dr["DateColumn"].ToString(),"dd-MM-yyyy HH:mm:ss",
                                                 CultureInfo.InvariantCulture);
}

answered Mar 30, 2014 at 16:48

Sudhakar Tillapudi

26.3k5 gold badges43 silver badges70 bronze badges

1 Comment

Cooper Over a year ago

Thank you very much, but DateTime.parse("String") did it

Dhamith Kumara · Accepted Answer · 2022-04-10 09:06:52Z

0

try this dateTimePicker_dob.Value = Convert.ToDateTime(dr[i].ToString());

in here i is the index of your DB column and dateTimePicker_dob is your dateTimePicker Design(Name)

answered Apr 10, 2022 at 9:06

Dhamith Kumara

86412 silver badges13 bronze badges

Collectives™ on Stack Overflow

Getting a datetime variable from a database using dataTableReader

4 Answers 4

1 Comment

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related