两个日期之间的日期验证差异 [英] date validation difference between two date

问题描述

嗨朋友

i有文字框拳头是出生日期，第二个是加入日期，我的问题是如何验证20年出生日期和加入日期之间的差异请帮助我



并且可以验证验证控件

解决方案

你需要定义存储过程 [ ^ ]在服务器端，其内容应如下所示：

 创建  PROCEDURE  GetUserAge 
  @ birthdate   DATETIME ，
  @ joindate   DATETIME  
 < span class =code-keyword> AS  
  BEGIN  
 
   -    SET @birthdate ='1977-07-07' 
   -    SET @joindate = GETDATE（） - 今天;） 
 
  SELECT  DATEDIFF（yy， @ birthdate ， @ joindate ） AS 年龄
  END  

更多：

DATEDIFF（ T-SQL） [ ^ ]

如何：在ASP.NET中调用SQL Server存储过程使用Visual C＃.NET [ ^ ]

hi friends
i have to text box fist is birth date and second is join date and my problem is how to validate difference between 20 year birth date and join date pls help me

and it is possible to validate to validation control

解决方案

You need to define stored procedure[^] on server side and its content should looks like:

CREATE PROCEDURE GetUserAge
    @birthdate DATETIME,
    @joindate DATETIME 
AS
BEGIN

--SET @birthdate = '1977-07-07'
--SET @joindate =GETDATE()  --today ;)

SELECT DATEDIFF(yy, @birthdate, @joindate) AS Age
END

More:
DATEDIFF (T-SQL)[^]
HOW TO: Call SQL Server Stored Procedures in ASP.NET by Using Visual C# .NET[^]

这篇关于两个日期之间的日期验证差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！