nuix时间戳转换

DATEDIFF(s, '19700101', '{1}')--nuix时间戳转换
 SELECT DATEDIFF(s, '19700101', '1988-12-18')

 

 CONVERT(int,DATEDIFF(mi,'1970-01-01 00:00:00', '1988-12-18')) * 60

 

--转换nuix时间，转换后加五小时，在转换成字符，格式化为常用日期格式 2009-01-01 00:00:00

update ecs_order_info set best_time = CONVERT(varchar(100),
(dateadd(hh,5,(dateadd(ss,add_time, '19700101 ')))),20)
where  add_time < 1230768000

--1230768000 为 2009-01-01 00:00:00

select dateadd(hh,5,(dateadd(ss,1263541259, '19700101 ')))

select dateadd(s,1263541259, '19700101 ')

SELECT datediff(s, '19700101', '2009-01-01 00:00:00')

select CONVERT(varchar(100),
(dateadd(hh,5,(dateadd(ss,1263541259, '19700101 ')))),20)

select add_time,best_time from ecs_order_info
 where  add_time < 1230768000