Subtract Hours from Current Timestamp

cyclogenisis · Post by **cyclogenisis** » Tue Apr 26, 2016 4:07 pm

Hello,

I am looking to get the current timestamp minus 5 hours. For example if right now is:

2016-04-26 18:01:15
It will return 2016-04-26 13:01:15

Another example if now is:
2016-04-26 01:01:15
It will return: 2016-04-25 20:01:15

Looking to do this in a user variable stage.

cyclogenisis · Post by **cyclogenisis** » Tue Apr 26, 2016 4:22 pm

chulett wrote:TimestampOffsetByComponents() ...

Thanks Craig. How would I get the full result in the desired format?

Also I mentioned I am trying to accomplish this in user variable stage. Does this function work in that stage?

chulett · Post by **chulett** » Tue Apr 26, 2016 4:25 pm

You were too quick. I removed my post when I noticed you said "in a User Variable stage" (which means a Sequence job) and I thought you were looking for a Parallel function. While I was removing it you replied.

No it does not and we're in the wrong forum to boot. Hang on a sec.

chulett · Post by **chulett** » Tue Apr 26, 2016 4:55 pm

Perhaps Ray is still giving away his BASIC routines to do date and time math, that would certainly make things easier. Otherwise I think you're going to need do some of your own. Something like:

1. IConv to convert the time to internal format
2. Subtract 18000 (5 hours in seconds)
3. Handle any 'underflow' including subtracting 1 day from the date
4. OConv to put it all back into a string

ray.wurlod · Post by **ray.wurlod** » Wed Apr 27, 2016 3:35 am

Click any of the links on my new home page which takes you to a public page on OneDrive. Download RayWurlodDateRoutines.dsx from there.

cyclogenisis · Post by **cyclogenisis** » Wed Apr 27, 2016 10:59 am

Hi Craig, what do you mean by underflow?

cyclogenisis · Post by **cyclogenisis** » Wed Apr 27, 2016 11:01 am

Thanks Ray, I see AddDaytoTimestamp, nothing with hourly I'll try to see how I can edit one of these and get familiar with building routines, don't have much experience in this area. However, I'm looking for a solution as quick as possible with since my time is very limited.

chulett · Post by **chulett** » Wed Apr 27, 2016 12:27 pm

Time in internal format is the number of seconds past midnight. When you subtract 18000 seconds from it, it may go negative which is what I meant by 'underflow'. When that happens, you need to decrement the day by 1 and then adjust the time accordingly... add back 86400 seconds... something I'm sure Ray is already doing and you can crib from if need be.

In other words, the scenario you covered in your second example.