get Current TimeStamp-(MINUS) 1 Day

nsm · Post by **nsm** » Thu Mar 12, 2009 2:42 pm

Hi,

My requirement is to get CurrentTimeStamp-(Minus)1Day.
I am using CurrentTimestampMS() function to give me CurrentTimeStamp with Microseconds.

In server job/Routine its easier to do this with ICONV/OCONV functions, can somebody help me to do this in parallel job?

Thanks
nsm.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 12, 2009 3:48 pm

Investigate the Julian date conversions.

nsm · Post by **nsm** » Tue Mar 17, 2009 1:36 pm

Ray,

I tried looking at Julian date functions but couldn't really see anything that does it.
There are functions that gives previous weekday but not date.

I didn't get an idea if there is a way to use Previous week day and get the date out of it.

Thanks
nsm.

us1aslam1us · Post by **us1aslam1us** » Tue Mar 17, 2009 1:46 pm

Have you checked the function TimestampFromSecondsSince()???

nsm · Post by **nsm** » Tue Mar 17, 2009 1:52 pm

my requirement is to get currenttimestamp in microseconds -(MINUS)1day.

Please help me in understanding how can I use TimestampFromSecondsSince() function to get what I wanted.

nsm.

chulett · Post by **chulett** » Tue Mar 17, 2009 2:41 pm

First you said current timestamp with microseconds and now current timestamp in microseconds... which one is it?