CREATE FUNCTION dbo.DATE2SECS
(
   @var_date datetime
)
/*
*   SSMA warning messages:
*   O2SS0356: Conversion from NUMBER datatype can cause data loss.
*/

RETURNS float(53)
AS
   
   /*
   *   Generated by SQL Server Migration Assistant for Oracle.
   *   Contact ora2sql@microsoft.com or visit http://www.microsoft.com/sql/migration for more information.
   */
   BEGIN

      DECLARE
         /*
         *   SSMA warning messages:
         *   O2SS0356: Conversion from NUMBER datatype can cause data loss.
         */

         @vartime float(53)

      SELECT @vartime = CAST(@var_date - CONVERT(datetime, '01-01-1970', 105) AS float(53)) * 24 * 60 * 60

      RETURN @vartime

   END
GO