sql - 浮点到日期时间

Question

我在尝试批量插入时遇到问题我只能让它与一个格式文件一起使用它说生日列是一个浮点数并将它放在一个临时表中但我想知道是否可以将生日转换回来到日期时间并将其从临时表插入到表中

CREATE TABLE CSVTempData
(
    MEMBERNUMBER float
      ,[FIRSTNAME] varchar(255)
      ,[MIDDLENAME] varchar(255)
      ,[LASTNAME]varchar(255)
      ,[BIRTHDATE] Float
      ,[GENDER] varchar(255)
      ,[MARITALSTATUS] varchar(255)
      ,[OCCUPATIONINDUSTRY] varchar(255)
      ,[OCCUPATIONTITLE]varchar(255)
      ,[ADDRESS1]varchar(255)
      ,[ADDRESS2]varchar(255)
      ,[CITY] varchar(255)
      ,[STATE] varchar(255)
      ,[POSTALCODE] float
      ,[HOMEPHONE] varchar(255)
      ,[CELLPHONE] varchar(255)
      ,[WORKPHONE] varchar(255)
      ,[EMAIL] varchar(255)
      ,[ALTERNATEEMAIL] varchar(255)
      ,[OPEN_DATE] Float
      ,[MARKETINGOPTION] varchar(255)

)



insert into SEV.dbo.MembersNew

select MEMBERNUMBER, FIRSTNAME ,MIDDLENAME,LASTNAME,  
cast  (cast (cast (Birthdate as int) as varchar (8)) as  datetime,   
GENDER ,MARITALSTATUS  ,OCCUPATIONINDUSTRY  ,OCCUPATIONTITLE,ADDRESS1,ADDRESS2,
      CITY ,STATE ,POSTALCODE,HOMEPHONE ,CELLPHONE,WORKPHONE ,EMAIL ,ALTERNATEEMAIL, 
      cast (cast (cast (Open_Date as int) as varchar) as datetime,   
      MARKETINGOPTION 

from CSVTempData

标签： sqlsql-serversql-server-2012