摘要：SELECT SUBSTRING(字段名, 1, 8) FROM 表名 SUBSTRING(expression, start, length)从第start个开始，截取长度为lengthLEFT(expression, length)返回从字符串左边开始指定个数的字符。RIGHT(expressi 阅读全文

摘要：DATEDIFF()函数返回两个日期之间的时间DATEDIFF(datepart,startdate,enddate) -- 获取两个日期之间的天数 SELECT DATEDIFF(day,'2021-01-01','2021-06-10') AS days; SELECT DATEDIFF(day 阅读全文

摘要：年月日时分秒毫秒SELECT GETDATE();SELECT CONVERT(VARCHAR, GETDATE(), 121);年月日时分秒SELECT CONVERT(VARCHAR, GETDATE(), 120);年月日SELECT CONVERT(VARCHAR, GETDATE(), 2 阅读全文