我想在VB.net和SQL服务器中找到下个月不到一天的日期 [英] I want to find next months date less than one day in VB.net and SQL server
问题描述
for Exampple今天的日期是5/10/2013我希望在sql server中有一个日期为4/11/2013而VB.net plz帮助我
您可以使用DATEADD
在SQL中执行此操作: http:// www。 w3schools.com/sql/func_dateadd.asp [ ^ ]
您可以在VB.net中使用AddMonth()
:
http://msdn.microsoft.com/en-us/library/system.datetime.addmonths.aspx?cs-save-lang=1&cs-lang=vb#code-snippet-1 [ ^ ]
您好,
请使用此项在 Ms sql中服务器,它会给你想要的结果
Quote:select dateadd(MONTH,1,GETDATE() - 1)
在VB.Net/ASP.net
MsgBox(DateAdd(DateInterval.Day,-1,Today.AddMonths(1))
希望这能解决你的问题
问候,
Mubin
你必须使用DATEADD
SQL Server的功能。
语法:
DATEADD (DatePart,Number,日期)
见下面命令,它将为您提供正确的结果:
SELECT DATEADD(MONTH, 1 ,DATEADD( DAY,-1,GETDATE()))或
DECLARE @TDATE DATETIME
SET @ TDATE = ' 2013-10-05' - 您可以在此处传递参数。
SELECT DATEADD(MONTH, 1 ,DATEADD(DAY,-1, @ TDATE ))
要将日期动态设置为参数,可以使用参数化SQL查询
并通过代码执行此查询:
_ mSqlCommand.CommandText = SELECT DATEADD(MONTH,1,DATEADD(DAY,-1,& 日期。现在。日期& )) ' 您可以在此处传递参数。或者 ASP.Net/VB.Net
< pre lang =vb> Dim _myDate 作为 日期 = 2013-10-05 ' 您可以在此处传递参数。
MsgBox(DateAdd(DateInterval.Day,-1,_ myDate.AddMonths( 1 )))
我希望这会对你有所帮助。 :)
for Exampple today date is 5/10/2013 i want a date as 4/11/2013 in sql server and VB.net plz help me
You can do this in SQL withDATEADD
: http://www.w3schools.com/sql/func_dateadd.asp[^]
You can do this in VB.net withAddMonth()
:
http://msdn.microsoft.com/en-us/library/system.datetime.addmonths.aspx?cs-save-lang=1&cs-lang=vb#code-snippet-1[^]
Hi ,
Please use this in Ms sql server, it will give you desired result
Quote:select dateadd("MONTH",1,GETDATE()-1 )
In VB.Net/ASP.net
MsgBox(DateAdd(DateInterval.Day,-1, Today.AddMonths(1) )
Hope this will solve your problem
Regards,
Mubin
You have to useDATEADD
Function of SQL Server.
Syntax :
DATEADD(DatePart, Number, Date)
See below Command which will give you the correct result :
SELECT DATEADD(MONTH,1,DATEADD(DAY,-1,GETDATE()))Or
DECLARE @TDATE DATETIME SET @TDATE = '2013-10-05' --You can pass your Parameter here. SELECT DATEADD(MONTH, 1, DATEADD(DAY,-1, @TDATE))
To dynamically set date as Parameter you can useParameterized SQL Query
and execute this query through code :
_mSqlCommand.CommandText = "SELECT DATEADD(MONTH, 1, DATEADD(DAY,-1, " & Date.Now.Date & "))"'You can pass your Parameter here.Or in ASP.Net/VB.Net
Dim _myDate As Date = "2013-10-05" 'You can pass your Parameter here. MsgBox(DateAdd(DateInterval.Day, -1, _myDate.AddMonths(1)))
I hope this will help you. :)
这篇关于我想在VB.net和SQL服务器中找到下个月不到一天的日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!