How to convert time to datetime

David Smith

How to convert time to datetime.

I am trying to send time to a datetime column.

So if I have 12:00 PM, how to convert to datetime , so i can send the value to the actual field in the database. I am trying to
insert the time values into the TimeFrom and TimeTo columns

Database columns,

ID, DateFrom, DateTo, TimeFrom, TimeTo

8 Replies

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

Mageshwaran R6y ago
Hi,
Try this code:
var dateStr = "14:00";
var dateTime = DateTime.ParseExact(dateStr, "H:mm", null, System.Globalization.DateTimeStyles.None);
0
Shebin babu7y ago
var dateStr = "14:00";
var dateTime = DateTime.ParseExact(dateStr, "H:mm", null, System.Globalization.DateTimeStyles.None);
0
Vulpes13y ago
If I were you, I'd use a fixed reference date.

The one that Anuja suggested - 1 January 2012 - is as good as any.

I'd then write a simple method which converts your time string into a DateTime representing the same time on the reference date:

static DateTime GetDateTime(string timeStr)
{
return DateTime.Parse("01/01/2012 " + timeStr);
}

and call it with code such as this:

DateTime dt = GetDateTime("12:00 AM");
Console.WriteLine(dt); // 01/01/2012 00:00:00
0
David Smith13y ago
Understood, so would some good logic to represent if a user choose anytime within a 24 hour time frame.
0
Sandeep Singh Shekhawat13y ago
TimeSpan ts = new TimeSpan(24);

DateTime dt = Convert.ToDateTime(ts.ToString());

Response.Write(dt);

Output:
12/10/2012 12:00:00 AM
0
David Smith13y ago
Sandeep what if the value is 12 AM instead of 12PM, how would i get 12 AM

from your logic below.

TimeSpan ts = new TimeSpan(12);

DateTime dt = Convert.ToDateTime(ts.ToString());
0
Sandeep Singh Shekhawat13y ago
TimeSpan ts = new TimeSpan(12);

DateTime dt = Convert.ToDateTime(ts.ToString());

Response.Write(dt);

It will give following output :

12/10/2012 12:00:00 PM

we can use dt variable for other operation ahead.
0
Anuja Pawar13y ago
No, its not possible directly as time is duration and its not date. But if you have reference date then you can do it.
DateTime dt = new DateTime(2012, 01, 01);
TimeSpan ts = new TimeSpan(1, 0, 0, 0, 0);
dt = dt + ts;
+1