当前日期:用Convert(varchar(10),getdate(),120);
当前时间:用Convert(varchar(8),getdate(),114);
返回这一天在第几周:DATEPART(weekday,getdate());
Powered by: 博客园 Copyright © 2024 茶^_^米 Powered by .NET 8.0 on Kubernetes