Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

HHMMSS int field to human-friendly time? Expand / Collapse
Author
Message
Posted Friday, May 3, 2013 7:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, June 15, 2014 9:18 PM
Points: 4, Visits: 58
Plenty of solutions already in place and I tried to built something from all:
select next_run_date,next_run_time,
CONVERT(CHAR(8), next_run_date, 112)+
CONVERT(datetime,STUFF(STUFF(RIGHT('000000' + CONVERT(VARCHAR(8), next_run_time), 6), 5, 0, ':'), 3, 0, ':'),108) next_datetime
from dbo.sysjobschedules

But, every solution looks good :)
Post #1449211
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse