How to get last hour from System time at Sequence?

kennyyeung.kw · Post by **kennyyeung.kw** » Mon Feb 14, 2011 2:15 am

I define a User Variables Activity and wanted to make 4 parameter base on the system datetime - 1 hour
year int
month int
day int
hour int
Is there any function i can use ?

ray.wurlod · Post by **ray.wurlod** » Mon Feb 14, 2011 3:51 am

Not one function, but you can build it up from more than one, including Date() or @DATE (date in internal format), Time() or @TIME (time in internal format) and doing the time arithmetic for the one hour offset. You could do all that in a server routine, too.

kennyyeung.kw · Post by **kennyyeung.kw** » Mon Feb 14, 2011 4:46 am

i dont know the function to perform the dateadd ..
i can get the date by @DATE
but i find no solution to get the date of (@Date - 1 hour )

chulett · Post by **chulett** » Mon Feb 14, 2011 7:33 am

You need to get the time as well, that or TimeDate() which gets both. And 1 hour = 3600 seconds, which is what you would need to subtract from the internal time, then convert back.

kennyyeung.kw · Post by **kennyyeung.kw** » Mon Feb 14, 2011 11:25 am

I know little about Datastage basic and
I can't find any function for dateadd
i have tried
Iconv(TimeDate(),"D") -3600
or
TimeDate() -3600
result is not correct

ray.wurlod · Post by **ray.wurlod** » Mon Feb 14, 2011 3:29 pm

However Time() - 3600 is correct. If that result is negative you have to subtract 1 from the date.

Code: Select all

If @TIME < 3600 Then Oconv(@DATE - 1, "D-YMD[4,2,2]") : " " : Oconv(@TIME + 86400 - 3600, "MTS") ElseOconv(@DATE, "D-YMD{4,2,2]") : " " : Oconv(@TIME - 3600, "MTS")

kennyyeung.kw · Post by **kennyyeung.kw** » Tue Feb 15, 2011 3:21 am

Problem Solved .. Thanks for help =]