topic SQL Command to display date in between in Application Development and Automation Discussions

SQL Command to display date in between

Former Member — Mon, 17 Mar 2008 22:46:07 GMT

Hello Friends

Is there any open sql command which will display sum(qty) between dates in one command , I know it is there like decode etc but cannot remember.

select sum(fkimg,010107 , 310107) from table into

wa where plant = xxxxxx

regards

Piroz

Former Member — Mon, 17 Mar 2008 23:05:11 GMT

Can't you just do this?


select sum(fkimg) 
from table into
wa where plant = xxxxxx
and date between '20070101' and '20070131'.

Greetings,

Blag.

Former Member — Tue, 18 Mar 2008 00:34:14 GMT

Yes I know doing by giving date range you can do it but if i need between this date to date

select * from s903

into wa where

fkdat between 010107 and 310107

how can i put the condition to display month wise individually

into jan,feb,mar,apr accordingly when the date range is selected it must go into each column separately

Is there any clue to start please, I am really stuck and it is very urgent

regards

Piroz