nvarchar的数据如:'24/08/2008 17:09:23' 怎么转换为 datetime格式???
解决方案 »
- sql查询简单问题
- 二个表相同记录过滤SQL写法
- 请问这个SQL语句怎么写,要匹配部分的字段字串?
- sql server 2005安装不起来,求高手帮忙
- 请问如何奖oracle的触发器换成sqlserver的触发器
- 请问:SELECT * FROM Table1 WHERE ID NOT IN (SELECT ID FROM Table2)的SQL如何改写成用JOIN的语句?
- 紧急求助一存储过程执行速度慢问题!
- decimal类型的字段,在select时,如果是空,则显示‘0.00’的问题
- 更新记录的问题,求救,在线等候。。。
- 请教高手!VFP6.0编译后时间变成不符合中国人习惯的01/01/2000如何解决?
- 求一个SQL语句
- 如何把sql sever 2000的实例完全转移到另一台服务器?
SET @n='24/08/2008 17:09:23'
SELECT CONVERT(DATETIME,REPLACE(@n,'/',' '),113)
insert into tb values('24/08/2008 17:09:23' )
goselect cast(substring(id , 7 , 4) + '-' +
substring(id , 4 , 2) + '-' +
substring(id , 1 , 2) +
substring(id , 11 , 9) as datetime)
from tbdrop table tb/*
------------------------------------------------------
2008-08-24 17:09:23.000(所影响的行数为 1 行)
*/
SET @n='24/08/2008 17:09:23'
select convert(varchar(10),convert(datetime,left(@n,10),103),120)+right(@n,9)-------------------
2008-08-24 17:09:23(1 row(s) affected)
declare @date nvarchar(50)set @date = '24/08/2008 17:09:23'select cast(substring(@date,7 , 4) + '-' + substring(@date , 4 , 2) + '-' + substring(@date , 1 , 2)+ substring(@date , 11 , 9) as datetime)
------------------------
2008-08-24 17:09:23.000
SET @n='24/08/2008 17:09:23'
SELECT CONVERT(DATETIME, @n ,103)
DECLARE @n NVARCHAR(50)
SET @n='24/08/2008 17:09:23'
SELECT CONVERT(DATETIME, @n ,103)/*
-----------------------
2008-08-24 17:09:23.000
(1 行受影响)*/