Changing time format

Results 1 to 2 of 2

Thread: Changing time format

  1. #1
    Join Date
    Dec 1969

    Default Changing time format

    I have a field in a SQL database that stores accumilated time in minutes. I want to make it so that when I bring up an ASP page that calls that variable it will show it in hours with the minutes remaining, ie. SQL = 78min, output is 1hour 18 min, something like that. Anyone know if it&#039;s possible or not?<BR><BR>thanks in advance for any help.

  2. #2
    Join Date
    Dec 1969

    Default Not advanced

    1) VBScript way:<BR><BR>FormatDateTime()<BR><BR>2) T-SQL way<BR><BR>CONVERT<BR><BR>Check both functions in the docs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts