以前写过一个方法,先去参考《T-SQL判断是否为今天》https://www.cnblogs.com/insus/archive/2012/03/22/2411209.html
今天使用一个更加简单的方法来实现:
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Insus.NET -- Create date: 2019-05-15 -- Update date: 2019-05-15 -- Description: 判断日期是不是今天 -- ============================================= CREATE FUNCTION [dbo].[svf_IsToday] ( @Date DATETIME ) RETURNS BIT AS BEGIN RETURN CASE WHEN DATEDIFF(dd,0,@Date) = DATEDIFF(dd,0,CURRENT_TIMESTAMP) THEN 1 ELSE 0 END END GO
实例演示: