How to convert time to datetime

Question

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

Anuja Pawar · Answer

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;

David Smith · Answer

Understood so would some good logic to represent if a user choose anytime within a 24 hour time frame.

Sandeep Singh Shekhawat · Answer

TimeSpan ts = new TimeSpan (24); DateTime dt = Convert .ToDateTime(ts.ToString()); Response.Write(dt); Output: 12/10/2012 12:00:00 AM

Sandeep Singh Shekhawat · Answer

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.

Vulpes · Answer

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

David Smith · Answer

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());