07-25-2013 07:39 AM
Hello, you folks helped me out immensely with figuring out how to turn the date of 1/1/1960 into a real date to be stored in an Oracle table. I have another question on how to turn that date, which is the CURRENT date, into the PREVIOUS days date. The following is the code.
* This gets the current Date.
%let curday=%sysfunc(date(), date9.);
* This loads the records into an Oracle table. the date portion hos_date is the date 7/25/2013 12:01:01 PM. I want it to be Yesterday's Date of 7/24/2013 12:01:01 PM
insert into safety.safety_hrs_svc
select dhms("&curday"d,12,01,01) as hos_date, STATION, CONTR_ID, CONTR_NAME, PRIM_SVC_AREA_ID, DRIVER_NBR, DRIVER_NAME, PCK_DELV_HRS, SPOT_HRS, LINEHAUL_HRS from work.safety_hrs;
Thank you very much.
07-25-2013 08:42 AM
OS2, that generates the following error..... cut from the log.
11 %let prevday=%sysfunc(date()-1, date9.);
ERROR: Expected close parenthesis after macro function invocation not found.
Thanks so much for looking.
Need further help from the community? Please ask a new question.