How to convert minutes to DateTime / DateTime to minute

Question

3.00/5 (2 votes)

See more:

my first problem : i have to convert 110 minute into time format means 01:50:00 (hh:mi:ss).
how to do this.?

my second problem : i have convert date to minute.But in that case i cant able to convert second into minute and add it to minute.
my calculation is here:
i have date : 1/9/2012 1:30:12AM
convert to minute returns : 90

SELECT     name1, address, mob, city, emailid,(datepart(hh,[date]) * 60) + datepart(n, [date]) + (datepart(ss,[date])/60)
FROM         [user.]

Posted 8-Feb-13 7:15am

Member 9511889

Updated 8-Feb-13 8:16am

Marco Bertschi

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Hasham Ahmad · Answer 1 · 2013-02-08T07:37:00

Solution 1

replace [YourInput] to your time in minuted

SQL

Select CAST(([YourInput] / 60) as varchar(2)) + ':' + CAST(([YourInput] % 60) as varchar(2))

the function can be found from the following location

http://stackoverflow.com/questions/2944580/minutes-to-time-in-sql-server[^]

Posted 8-Feb-13 7:37am

Hasham Ahmad

PIEBALDconsult · Answer 2 · 2013-02-08T07:57:00

Solution 2

new System.TimeSpan ( 0 , 150 , 0 ).ToString()

System.DateTime d = System.DateTime.Parse ( "1/9/2012 1:30:12" ) ;
double minutes = d.TimeOfDay.TotalMinutes ;

This yields 90.2 -- what you do with the fractional part is up to you; Round, Ceiling, Floor, etc.

And if you want your SQL to add the seconds as partial minutes, you can change the second 60 to 60.0 -- you should then get 90.2 there are well.

Posted 8-Feb-13 7:57am

PIEBALDconsult

Updated 8-Feb-13 10:03am

v3

Comments

Hasham Ahmad 8-Feb-13 14:15pm

he is looking to do it in SQL server

Richard C Bishop 8-Feb-13 14:19pm

The thread is tagged wrong.

PIEBALDconsult 8-Feb-13 14:20pm

I wouldn't assume that.

PIEBALDconsult 8-Feb-13 14:20pm

No, he's looking for a C# answer -- see the tags.

Richard C Bishop 8-Feb-13 14:25pm

Look at the code he posted though, it is not C#. Nowhere in his post does it mention any language other than the code posted.

PIEBALDconsult 8-Feb-13 14:28pm

It's in the tags.

He's asking for a C# version of the SQL code -- lots of people ask for language translations.