Current Month

一个

请问一下，SQL select statement 有没有办法选出 'current month' 的records吗？

tandan999

当然可以了，直接读取年月

一个

好比以下？？？

1. select cust_name, inv_date, inv_no, inv_amt from INVOICE where (select month(inv_date) as month = (select MONTH(CURRENT_DATE())) and ORDER BY inv_no

复制代码

雪儿与小鱼儿

你可以尝试一下 t-sql

1. 
   
2. SELECT * FROM (SEELCT cust_name, inv_date, inv_no, inv_amt, DATENAME(month, inv_date) AS tmonth FROM INVOICE) AS Table1
   
3. WHERE (tmonth = 'March')
   
4. ORDER BY inv_no
   

复制代码

html

Get the current month value: Month(getdate())  or  Datename(m,getdate())

黄昏十二月

Month("Your Month Column") = Month(GETDATE())