Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jano Petras Get DATE part of the DATETIME RE: Get DATE part of the DATETIME

  • April 4, 2008 at 5:56 am

    #798339

    Thanks for info Jano Petras,

    Internally - datetime is just 8-byte FLOAT number as stored by SQL Server

    Could you provide the same info about the datatypes DATE & DATETIME2 in the proposed SQL Server 2008.

    I am asking this because of limitation of the datetime type in SQL Server 2005 not to accept dates outside the date range from January 1, 1753 and December 31, 9999

    The below SQL will result error in SQL Server 2005

    SELECT CAST(FLOOR(CAST(cast('1752-12-31' as datetime) AS FLOAT)) AS DATETIME)

    Best regards,

    Maz

    -----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]