sql:
SELECT
convert(char(10), DATEADD(dd,number,'2017-06-13'),120) AS yyyymmdd
FROM
master..spt_values
WHERE
type = 'p'
AND DATEDIFF(MI,DATEADD(dd,number,'2017-06-13'),'2017-06-17') > 0
公司最近升级了数据库,升级版本为
Microsoft SQL Server 2016 (SP2-CU6) (KB4488536) - 13.0.5292.0 (X64)
Mar 11 2019 23:19:30
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 R2 Datacenter 6.3 <X64> (Build 9600: ) (Hypervisor)
升级后,type='p' 无法查询到,需要更改为type='P' 由原来的小写改为现在的大写了
很奇怪!!!