Adding time...

Question

Adding time...

FreeHansje

SSChampion

Points: 11751
More actions
October 11, 2011 at 8:43 am

#249854

I know about the DateDiff and DateAdd functions, but how do I add the sysjobhistory..run_duration to a date?
Greetz,
Hans Brouwer

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

bkubicek SSChampion Points: 10948 More actions · Answer 1

FreeHansje (10/11/2011)
I know about the DateDiff and DateAdd functions, but how do I add the sysjobhistory..run_duration to a date?

check out this post:

http://www.sqlservercentral.com/Forums/Topic206218-5-1.aspx

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 2

check out this earlier thread... there are a couple of ways to get the value into a usable format.

http://www.sqlservercentral.com/Forums/Topic3686-5-1.aspx

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 3

bkubicek (10/11/2011)
FreeHansje (10/11/2011)
I know about the DateDiff and DateAdd functions, but how do I add the sysjobhistory..run_duration to a date?
check out this post:
http://www.sqlservercentral.com/Forums/Topic206218-5-1.aspx

great timing bkupicek

Phil Parkin SSC Guru Points: 247159 More actions · Answer 4

great timing bkupicek

You can say that again.

Or can you?

bkubicek SSChampion Points: 10948 More actions · Answer 5

Phil Parkin (10/11/2011)
great timing bkupicek
You can say that again.
Or can you?

You can say it again, but spell my name right kubicek!

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 6

bkubicek (10/11/2011)
Phil Parkin (10/11/2011)
great timing bkupicek
You can say that again.
Or can you?
You can say it again, but spell my name right kubicek!

Sorry mate - kubicek!! :blush:

FreeHansje SSChampion Points: 11751 More actions · Answer 7

Tnx for answering all, very useful info in these links, I can work with that.

Greetz,
Hans Brouwer

Adding time...

Cookies on SQLServerCentral