我有一个表,它看起来像这样:
datestamp
2020-04-01
2020-04-02
我试着做两件事:
- 将日期戳转换为日期格式,因为现在是ABC
- 获取日期戳与今年年底(2020-12-31(之间的差异
这样我就会得到这样的结果:
datestamp diff
2020-04-01 275
2020-04-02 274
我尝试过的:
DATEDIFF(day, datestamp, '2020-12-31 00:00:00.0000000')
我得到:
DATEDIFF(日期,日期戳,'2020-12-31 00:00:00.0000000000'(
我的错误在哪里?
只需减去值:
select datestamp, date '2020-12-31' - datestamp as diff
from the_table;
这假设datestamp
是date
列。