Format time

[SQL2KDBA69]

im trying to format 600 sec to mins and seconds. So i want 600s to look like 10:00 which is the mm:ss format.

thanks in advance

 

[ThatRickGuy]

You could throw them into a string manually.

public function FormatSeconds(Seconds as integer) as string
  dim iMinutes = Seconds \ 10
  dim iSeconds as integer = Seconds MOD 10
  return iMinutes & ":" & iSeconds
end function

Or you could try a timespan (I have no idea if this will work, it just popped into my head:

  Dim ts As TimeSpan = TimeSpan.FromSeconds(600)
  mystring = ts.Minutes & ":" & ts.seconds

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[arunacss]

public function FormatSeconds(Seconds as integer) as string
dim iMinutes = Seconds \ 60
dim iSeconds as integer = Seconds MOD 60
return iMinutes & ":" & iSeconds
end function