Convert Second to Time format

• aziz

  Old Hand

  Points: 301

  More actions

  January 21, 2002 at 5:55 am

  #78104

  Can anybody help me to convert 91423 second to hh:mm:ss within Sql select statment.

• jG

  SSCrazy

  Points: 2505

  More actions

  January 21, 2002 at 6:44 am

  #422364

  See if this helps:

  Select dateadd(ss, 91423, 0) -JG

  
  -JG