从日期时间 SQL Server 2005 当前月份和当前年份的特定日期

2021-09-10 00:00:00 sql sql-server-2005 tsql sql-server

大家好，我想在今天之前从发票和客户中搜索数据我正在使用 DateDiff() GETDATE() 函数，例如两个表

Hello everyone i want search data from invoices and client by today date I'm using DateDiff() GETDATE() functions for example two tables

1 个客户

 - ID   int
 - Name Varcher

2 发票

 - ID int
 - ClientID int
 - date  Datetime
 - Total  money

查询

 Select * from client c 
 inner join invoice i on c.id = i.ClientID 
 WHERE DateDiff(dd, i.date, getdate()) = 0

我想从日期时间按当前月份和当前年份的特定日期选择查询如果当前月份是 08 和当前年份 2010 我想写一个月的任何一天谢谢大家帮我

I want select query by specific day of current month and current year from date time if the current month is 08 and current year 2010 i want write any day of month Thanks every one help me

推荐答案

从当前月份和年份中的特定日期选择记录的最简单方法是声明一个分配给指定日期、月份和年份的 datetime 变量，以及用变量替换查询中的 getdate() - 像这样:

The simplest way to select records from a specific day in the current month and year is to declare a datetime variable assigned to the specified day, month and year, and replace getdate() in your query with the variable - like so:

declare @date datetime 

select @date = '10-Aug-2010'

Select * from client c 
inner join invoice i on c.id = i.ClientID 
WHERE DateDiff(dd, i.date, @date) = 0

要在当前月份的指定日期运行查询，请尝试以下操作:

To run a query for a specified day of the month in the current month, try the following:

declare @day integer

select @day = 10

Select * from client c 
inner join invoice i on c.id = i.ClientID 
WHERE DateDiff(dd, i.date, dateadd(dd,@day-datepart(dd,getdate()),getdate())) = 0

相关文章