将分钟转换为d:hh:mm:ss格式 [英] Convert Minutes into d:hh:mm:ss format

问题描述

如何在asp.net或sql中将分钟转换为d:hh:mm:ss

How to convert minutes into d:hh:mm:ss in asp.net or sql

推荐答案

刚才我写了这个.您必须为其添加一些额外的代码才能获得完美的输出.这里只是您的问题的主意.

Hi,

Just now I write this.You''ve to add some additional code for it to get perfect output.Here just ''m giving idea on your question.

int inp = int.Parse(TextBox1.Text);
      int d = 0, h = 0, min = 0, se = 0;
      d = inp / 1440;
      inp = inp % 1440;
      if (inp > 59)
      {
          h = inp / 60;
          inp = inp % 60;
          if (inp > 60)
          {
              min = inp / 60;
              inp = inp % 60;
              se = inp;
          }
          else
          {
              min = inp;
          }

      }
      else
      {
          h = inp;
      }

尝试使用上面的代码来生成您的需求.稍后，我将为其发布完美的代码K

希望您能理解我说的话.

Try the above code for generating your requirement.In soon I''ll post perfect code for it K

I hope u''ll uderstand what I said.

尝试一下

int min = DateTime.Now.Minute;
TimeSpan output = new TimeSpan(0,min,0);
string str = output.ToString().Replace(".",":");

用于Sqlserver

for Sqlserver

declare @min int
set @min = 1561
select @min / 1440  days,
(@min / 60) % 24 hours, 
@min % 60 minutes

这篇关于将分钟转换为d:hh:mm:ss格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！