根據當前月份計算前五個月的數據. ( 积分: 100 )

H

hn_yxb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-03-14

• #1

環境：delphi&nbsp;,sql-server.<br>&nbsp;&nbsp;&nbsp;我現在的問題是：<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;根據當前月份計算前五個月的數據,我現在的難點，就是怎么判斷前五個月的月份.<br>&nbsp;&nbsp;&nbsp;請各位指點.

 

S

ssstudio

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-03-14

• #2

month(getdate())&nbsp;返回的就是月份

 

流

流水先生

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-03-14

• #3

datediff(month,DateField,getdate())&lt;=5

 

H

hn_yxb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-03-14

• #4

各位好,假如現在是3月份，我怎么取的前5個月呢?<br>2006.10,<br>2006.11,<br>2006.12,<br>2007.01<br>2007.02

 

K

kaida

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-03-14

• #5

select&nbsp;*&nbsp;from&nbsp;YourTable&nbsp;<br>where&nbsp;datediff(month,YourDateField,getdate())&lt;=5

 

H

hn_yxb

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-03-20

• #6

誰有沒有這個方面的資料，給我參考一下。<br>mail&nbsp;Add:yangxbmail.cn@tom.com