Convert

• gstarsaini

  Ten Centuries

  Points: 1010

  More actions

  April 2, 2014 at 9:08 am

  #306040

  What actually happens when I convert date to float?

  Select convert(float,getdate(),112)

• gsc_dba

  SSCertifiable

  Points: 5407

  More actions

  April 2, 2014 at 9:34 am

  #1702526

  You get a float value that is n days since Jan 01 1900 00:00:00

  Select convert(float,getdate(),112)

  SELECT CONVERT(DATETIME,41729.6878646605 )

  gsc_dba