SDU Tools 151 Converting datetime values between Excel and SQL Server
SDU Tools are free tools and example T-SQL code for SQL Server developers and DBAs. When converting data, you can need to take date and time values from Excel and convert them to/from SQL Server datetime data types. ExcelSerialToDateTime converts an Excel serial datetime type to a SQL Server datetime. DateTimeToExcelSerial does the reverse.
To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com