例如:日期2021-12-31
日期格式:2021-12-31 数值格式:44561
将日期转化为日期格式后进行加减
SQL Server:
select DATEADD(day, 数值格式,cast('1899/12/30' as date)) from test1
如:select DATEADD(day, 44561,cast('1899/12/30' as date)) from test1
select DATEDIFF(day, cast('1899/12/30' as date), cast( 日期格式 as date)) from test1
如:select DATEDIFF(day, cast('1899/12/30' as date), cast('2021/12/31' as date)) from test1
Oracle:
select to_date('1899/12/30', 'YYYY/MM/DD') + 数值格式 from dual
如:select to_date('1899/12/30', 'YYYY/MM/DD') + 44561 from dual
select to_date( 日期格式 , 'YYYY/MM/DD') - to_date('1899/12/30', 'YYYY/MM/DD') from dual
如:select to_date('2021/12/31', 'YYYY/MM/DD') - to_date('1899/12/30', 'YYYY/MM/DD') from dual