自定义类型试试这个:update 表 set departureTime= substring(departureTime,12,8)
create table test(t nvarchar(50)) insert test values('1899-12-30 18:05:00') insert test values('1899-12-30 18:06:00') insert test values('1899-12-30 18:07:00') insert test values('1899-12-30 18:08:00') insert test values('1899-12-30 18:09:00') insert test values('1899-12-30 18:10:00')update test set t=CONVERT(varchar(100), CONVERT(datetime,t), 24) select * from test /* 18:05:00 18:06:00 18:07:00 18:08:00 18:09:00 18:10:00 */
自定义类型试试这个:update 表 set departureTime= substring(departureTime,12,8)成功了,谢谢您的耐心解答!
set departureTime= substring(departureTime,12,8)
create table test(t nvarchar(50))
insert test values('1899-12-30 18:05:00')
insert test values('1899-12-30 18:06:00')
insert test values('1899-12-30 18:07:00')
insert test values('1899-12-30 18:08:00')
insert test values('1899-12-30 18:09:00')
insert test values('1899-12-30 18:10:00')update test set t=CONVERT(varchar(100), CONVERT(datetime,t), 24)
select * from test
/*
18:05:00
18:06:00
18:07:00
18:08:00
18:09:00
18:10:00
*/
自定义类型试试这个:update 表
set departureTime= substring(departureTime,12,8)成功了,谢谢您的耐心解答!