Page 1 of 1

get Current TimeStamp-(MINUS) 1 Day

Posted: Thu Mar 12, 2009 2:42 pm
by nsm
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.

Posted: Thu Mar 12, 2009 3:48 pm
by ray.wurlod
Investigate the Julian date conversions.

Posted: Tue Mar 17, 2009 1:36 pm
by nsm
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.

Posted: Tue Mar 17, 2009 1:46 pm
by us1aslam1us
Have you checked the function TimestampFromSecondsSince()???

Posted: Tue Mar 17, 2009 1:52 pm
by nsm
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.

Posted: Tue Mar 17, 2009 2:41 pm
by chulett
First you said current timestamp with microseconds and now current timestamp in microseconds... which one is it? :?