11 2021 档案
摘要：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
阅读全文
摘要：function dateDiffStr(startDateStr, endDateStr) { var day = 0; var separator = "-"; //日期分隔符 var date1 = startDateStr.substring(0, 10).split(separator);
阅读全文
摘要：年月日时分秒毫秒SELECT GETDATE();SELECT CONVERT(VARCHAR, GETDATE(), 121);年月日时分秒SELECT CONVERT(VARCHAR, GETDATE(), 120);年月日SELECT CONVERT(VARCHAR, GETDATE(), 2
阅读全文
