Achieve the MIDNIGHT_SECONDS clause of DB2 in SAS proc sql

[Nehcour0420]

Hi ,

I redeveloping some ETL job from DB2 to SAS and having a problem. The previous work used MIDNIGHT_SECONDS (Returns an integer value in the range 0 to 86 400, representing the number of seconds between midnight and the time value specified in the argument.) clause which only could be used in DB2 and I am wondering if there is any way the achieve the same function in SAS using proc sql.

eg.

INT(MIDNIGHT_SECONDS(process_time)/900) AS timeslice

Thanks,

Eric

[data_null__ · Accepted solution]

SAS time values are "MIDNIGHT SECONDS".  You can read 'hh:mm:ss' fields with a TIME informat as SAS will store the value as SAS/TIME.