新增文章

文章标题 分类 C# 云星空 K3 BOS K3 功能 用友 Oracle python SQL MySql PHP HTML script windows Access 影视后期 财务 服务 生活 内容 declare @time datetime; select @time = getDate(); -- 2081-03-24 21:39:45.590 select 单据日期 < convert(varchar(20),getDate(),23) ---------------------------------------------------------------------------------------------------------- --【常用】 declare @time datetime; set @time = '2081-03-24 21:39:45.589'; select convert(varchar(100), @time, 112) -- 20810324 ,convert(varchar(100), @time, 12) -- 810324 select convert(varchar(100), @time, 21) -- 2081-03-24 21:39:45.590 ,convert(varchar(100), @time, 20) -- 2081-03-24 21:39:45 ,convert(varchar(100), @time, 23) -- 2081-03-24 select convert(varchar(100), @time, 14) -- 21:39:45:590 ,convert(varchar(100), @time, 24) -- 21:39:45 select convert(varchar(100), @time, 111) -- 2081/03/24 ,convert(varchar(100), @time, 11) -- 81/03/24 select convert(varchar(100), @time, 102) -- 2081.03.24 ,convert(varchar(100), @time, 2) -- 81.03.24 ---------------------------------------------------------------------------------------------------------- select convert(varchar(100), @time, 114) -- 21:39:45:590 ,convert(varchar(100), @time, 14) -- 21:39:45:590 ,convert(varchar(100), @time, 8) -- 21:39:45 ,convert(varchar(100), @time, 24) -- 21:39:45 ,convert(varchar(100), @time, 108) -- 21:39:45 ---------------------------------------------------------------------------------------------------------- select convert(varchar(100), @time, 112) -- 20810324 ,convert(varchar(100), @time, 12) -- 810324 ---------------------------------------------------------------------------------------------------------- select convert(varchar(100), @time, 23) -- 2081-03-24 ,convert(varchar(100), @time, 120) -- 2081-03-24 21:39:45 ,convert(varchar(100), @time, 20) -- 2081-03-24 21:39:45 ,convert(varchar(100), @time, 121) -- 2081-03-24 21:39:45.590 ,convert(varchar(100), @time, 21) -- 2081-03-24 21:39:45.590 ,convert(varchar(100), @time, 25) -- 2081-03-24 21:39:45.590 ---------------------------------------------------------------------------------------------------------- select convert(varchar(100), @time, 105) -- 24-03-2081 ,convert(varchar(100), @time, 5) -- 24-03-81 ,convert(varchar(100), @time, 110) -- 03-24-2081 ,convert(varchar(100), @time, 10) -- 03-24-81 ---------------------------------------------------------------------------------------------------------- select convert(varchar(100), @time, 111) -- 2081/03/24 ,convert(varchar(100), @time, 11) -- 81/03/24 ,convert(varchar(100), @time, 101) -- 03/24/2081 ,convert(varchar(100), @time, 1) -- 03/24/81 ,convert(varchar(100), @time, 103) -- 24/03/2081 ,convert(varchar(100), @time, 3) -- 24/03/81 ,convert(varchar(100), @time, 22) -- 03/24/81 9:39:45 PM ---------------------------------------------------------------------------------------------------------- select convert(varchar(100), @time, 102) -- 2081.03.24 ,convert(varchar(100), @time, 2) -- 81.03.24 ,convert(varchar(100), @time, 104) -- 24.03.2081 ,convert(varchar(100), @time, 4) -- 24.03.81 ---------------------------------------------------------------------------------------------------------- select convert(varchar(100), @time, 106) -- 24 03 2081 ,convert(varchar(100), @time, 6) -- 24 03 81 ,convert(varchar(100), @time, 113) -- 24 03 2081 21:39:45:590 ,convert(varchar(100), @time, 13) -- 24 03 2081 21:39:45:590 select convert(varchar(100), @time, 100) -- 03 24 2081 9:39PM ,convert(varchar(100), @time, 0) -- 03 24 2081 9:39PM ,convert(varchar(100), @time, 109) -- 03 24 2081 9:39:45:590PM ,convert(varchar(100), @time, 9) -- 03 24 2081 9:39:45:590PM ---------------------------------------------------------------------------------------------------------- select convert(varchar(100), @time, 107) -- 03 24, 2081 ,convert(varchar(100), @time, 7) -- 03 24, 81 ---------------------------------------------------------------------------------------------------------- select convert(varchar(100), @time, 126) -- 2081-03-24T21:39:45.590 select convert(varchar(100), @time, 130) -- 14 ????? ??????? 1504 9:39:45:590PM ,convert(varchar(100), @time, 131) -- 14/06/1504 9:39:45:590PM 返回 保存