convert Excel Date Serial Number to Regular Date

by

In SQL:

select dateadd(d,36464,'1899-12-30')
-- or thanks to rcdmk
select CAST(36464 - 2 as SmallDateTime)

In SSIS, see here

http://msdn.microsoft.com/en-us/library/ms141719.aspx

More Related Contents:

  1. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  2. Automate Version number Retrieval from .Dtsx files
  3. Query a database based on result of query from another database
  4. SSIS Source Format Implicit Conversion for Datetime
  5. How to Map Input and Output Columns dynamically in SSIS?
  6. Calculate a Running Total in SQL Server
  7. Subquery using Exists 1 or Exists *
  8. Truncate (not round) decimal places in SQL Server
  9. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  10. Select statement to find duplicates on certain fields
  11. Getting only Month and Year from SQL DATE
  12. Update records in table from CTE
  13. Dynamic Pivot Columns in SQL Server
  14. INT vs Unique-Identifier for ID field in database
  15. How to send email from SQL Server?
  16. How To Create Table with Identity Column
  17. Why do you create a View in a database?
  18. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  19. How to split string using delimiter char using T-SQL?
  20. Calculate the number of records for each date between 2 dates
  21. T-SQL: How to use parameters in dynamic SQL?
  22. How to compare datetime with only date in SQL Server
  23. Merge overlapping date intervals
  24. SQL server select distinct rows using most recent value only
  25. Split words with a capital letter in sql
  26. SQL poor stored procedure execution plan performance – parameter sniffing
  27. Eliminate and reduce overlapping date ranges
  28. scope_identity vs ident_current
  29. COALESCE Function in TSQL
  30. Convert bigint to datetime

Leave a Comment