Convert .NET Ticks to SQL Server DateTime

by

I don’t really know SQL Server, but today a colleague of mine had the same problem and I think I’ve found a solution like this:

CAST(([ticks] - 599266080000000000) / 10000000 / 24 / 60 / 60 AS datetime)

where 599266080000000000 is the ticks value for 01/01/1900 00:00:00.

More Related Contents:

  1. Convert SQL server datetime fields to compare date parts only, with indexed lookups
  2. Base64 encoding in SQL Server 2005 T-SQL
  3. SQL query to select dates between two dates
  4. Integer division in sql server
  5. Nested stored procedures containing TRY CATCH ROLLBACK pattern?
  6. How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?
  7. Showing Difference between two datetime values in hours
  8. Measuring code execution time
  9. get DATEDIFF excluding weekends using sql server
  10. SQL query to find Missing sequence numbers
  11. SQL Query to find the last day of the month
  12. What is the easiest way to subtract time in C#?
  13. How to use alias column name in where clause in SQL Server
  14. subquery or leftjoin with group by which one is faster?
  15. Calculating timespan with t-sql
  16. SQL Dynamic Pivot – how to order columns
  17. How to update data in one table from corresponding data in another table in SQL Server 2005
  18. Foreign key relationship with composite primary keys in SQL Server 2005
  19. Unique Key Violation in SQL Server – Is it safe to assume Error 2627?
  20. Can you round a .NET TimeSpan object?
  21. How to recover deleted rows from SQL server table?
  22. SQL Server 2005 – using generated sequences instead of Identity columns?
  23. What good are SQL Server schemas?
  24. Work with a time span in Javascript
  25. Problem with Renaming a Column in SQL Server
  26. What is the internal representation of datetime in sql server?
  27. Convert UTC Milliseconds to DATETIME in SQL server
  28. DateTime precision in NHibernate and support for DateTime2 in NHibernate SchemeExport
  29. Multiple Select Statements using SQL Server 2005 “WITH” Statement
  30. How do you store a picture in an image column?

Leave a Comment