kshatriya24 (6/13/2013)
Can you please help me converting datediff into seconds. I'm using SQL 2008 , the following command error out with pass valid argument.round((ENDDTTM - BEGINDTTM) * 24 * 60 * 60) || ' seconds' as PROCSTIME .
Thank you
SELECT DATEDIFF(SECOND, BEGINDTTM, ENDDTTM) from YourTable;