在sqlserver 2005中将nVarcher数据类型字段转换为Datetime数据类型 [英] Convert nVarcher Data type Field to Datetime Data type in sqlserver 2005

问题描述

我有一个具有数据库字段nvarchar的现有项目，但它应该是日期时间数据类型.现在我想将其转换为日期时间，但无需碰到前int边码.我在数据库中有大量数据.测试了另一个地方，当我更改数据类型时，我错过了所有数据.我处于深层修复中.
我该如何处理.如何在不丢失数据的情况下更改数据库字段类型.
我是新手开发人员，所以
任何帮助都会令我感激
Masud

Hi,
I have got a existing project that have database field nvarchar but it should be date time data type.Now I want to convert it date time but without touch of front int side code.I have a large number of data in data base.I have tested another place,when I change data type I have missed all of my data.I am in a deep fix.
How can I handle this matter.How can i change database Field Type without loosing data.
I am a novice developer,so
Any help will make me grateful
Masud

推荐答案

您需要使用以下代码行将nvarchar数据更改为日期时间.这只是一个示例，您如何将nvarchar更改为datetime.

You need to change your nvarchar data into datetime by using below line of code. It''s only example how can you change your nvarchar to datetime.

DECLARE @strFirstDate   varchar(20),
    @strSecondDate  varchar(20)
SELECT  @strFirstDate   = '20060120112128',
    @strSecondDate  = '20060120112659'
SELECT  CONVERT(datetime, LEFT(@strFirstDate, 8) + ' ' + substring(@strFirstDate, 9, 2) + ':' + substring(@strFirstDate, 11, 2) + ':' + substring(@strFirstDate, 13, 2)),
    CONVERT(datetime, LEFT(@strSecondDate, 8) + ' ' + substring(@strSecondDate, 9, 2) + ':' + substring(@strSecondDate, 11, 2) + ':' + substring(@strSecondDate, 13, 2)),
    DATEDIFF(Minute,    -- Or Hours / Seconds / whatever
        CONVERT(datetime, LEFT(@strFirstDate, 8) + ' ' + substring(@strFirstDate, 9, 2) + ':' + substring(@strFirstDate, 11, 2) + ':' + substring(@strFirstDate, 13, 2)),
        CONVERT(datetime, LEFT(@strSecondDate, 8) + ' ' + substring(@strSecondDate, 9, 2) + ':' + substring(@strSecondDate, 11, 2) + ':' + substring(@strSecondDate, 13, 2))
        )

希望它对您有用.

I hope it works for you.

这篇关于在sqlserver 2005中将nVarcher数据类型字段转换为Datetime数据类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！