Home Forums SQL Server 2005 T-SQL (SS2K5) Converting Quartz.Net time columns to datetime RE: Converting Quartz.Net time columns to datetime

  • November 29, 2010 at 7:54 am

    #1256265

    Jeff Moden (11/25/2010)

    This will do it...

    DECLARE @Ticks BIGINT

    SELECT @Ticks = 634262130000000000

    SELECT Converted = CAST(@Ticks/864000000000.0 - 693595.0 AS DATETIME)

    Thank you. Would you mind explaining what the magic numbers are in the cast statement?