topic Achieve the MIDNIGHT_SECONDS clause of DB2 in SAS proc sql in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Achieve-the-MIDNIGHT-SECONDS-clause-of-DB2-in-SAS-proc-sql/m-p/78490#M684 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I redeveloping some ETL job from DB2 to SAS and having a problem. The previous work used MIDNIGHT_SECONDS (<SPAN style="color: #000000; font-family: Arial, sans-serif; text-align: -webkit-auto; background-color: #ffffff;">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.</SPAN>) 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.</P><P></P><P>eg.</P><P></P><P>INT(MIDNIGHT_SECONDS(process_time)/900) AS timeslice</P><P></P><P></P><P>Thanks,</P><P>Eric</P></BODY></HTML> Mon, 30 Jul 2012 19:10:31 GMT Nehcour0420 2012-07-30T19:10:31Z Achieve the MIDNIGHT_SECONDS clause of DB2 in SAS proc sql https://communities.sas.com/t5/SAS-Data-Management/Achieve-the-MIDNIGHT-SECONDS-clause-of-DB2-in-SAS-proc-sql/m-p/78490#M684 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I redeveloping some ETL job from DB2 to SAS and having a problem. The previous work used MIDNIGHT_SECONDS (<SPAN style="color: #000000; font-family: Arial, sans-serif; text-align: -webkit-auto; background-color: #ffffff;">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.</SPAN>) 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.</P><P></P><P>eg.</P><P></P><P>INT(MIDNIGHT_SECONDS(process_time)/900) AS timeslice</P><P></P><P></P><P>Thanks,</P><P>Eric</P></BODY></HTML> Mon, 30 Jul 2012 19:10:31 GMT https://communities.sas.com/t5/SAS-Data-Management/Achieve-the-MIDNIGHT-SECONDS-clause-of-DB2-in-SAS-proc-sql/m-p/78490#M684 Nehcour0420 2012-07-30T19:10:31Z Re: Achieve the MIDNIGHT_SECONDS clause of DB2 in SAS proc sql https://communities.sas.com/t5/SAS-Data-Management/Achieve-the-MIDNIGHT-SECONDS-clause-of-DB2-in-SAS-proc-sql/m-p/78491#M685 <HTML><HEAD></HEAD><BODY><P>SAS time values are "MIDNIGHT SECONDS".&nbsp; You can read 'hh:mm:ss' fields with a TIME informat as SAS will store the value as SAS/TIME.</P></BODY></HTML> Mon, 30 Jul 2012 19:35:30 GMT https://communities.sas.com/t5/SAS-Data-Management/Achieve-the-MIDNIGHT-SECONDS-clause-of-DB2-in-SAS-proc-sql/m-p/78491#M685 data_null__ 2012-07-30T19:35:30Z