某月開始時間結束時間

某月開始時間結束時間| Id | Title | DateAdded | SourceUrl | PostType | Body | BlogId | Description | DateUpdated | IsMarkdown | EntryName | CreatedTime | IsActive | AutoDesc | AccessPermission |

| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------| -------------|
| 16938004| 某月開始時間結束時間| 2022-11-30T11:55:00| | BlogPost|

 

 

 

這個能用

 

http://www.itpub.net/thread-1836567-1-1.html

 

select dn.postDate

   from TBL_CRM_DELIVERYNOTE dn

 where dn.postDate >=

        trunc(to_date('2015-03', 'YYYY-MM'), 'mm')

    and dn.postDate <

        add_months(trunc(to_date('2015-03', 'YYYY-MM'), 'mm'),1)

 and dn.bStatus = 209201 order by dnlId desc

 

 

 

 

 

 

select dn.shiptoNo as shiptoNo,dn.shiptoName as shiptoName,  SUM(dn.dCount) AS dCount from TBL_CRM_DELIVERYNOTE dn where   

dn.createDate between trunc(to_date('2015-01-01 00:00:00','YYYY-MM'),'mm')

 and add_months(trunc(to_date('','YYYY-MM'),'mm'),1) and dn.bStatus = 209201

 and dn.tzFlag = 209101 GROUP BY dn.shiptoNo,dn.shiptoName order by shiptoNo

 

 

 

select dn.shiptoNo as shiptoNo,dn.shiptoName as shiptoName,  SUM(dn.dCount) AS dCount

 from TBL_CRM_DELIVERYNOTE dn where   dn.createDate between trunc(to_date('2015-01','YYYY-MM'),'mm')

and add_months(trunc(to_date('2015-01','YYYY-MM'),'mm'),1)

 and dn.bStatus = 209201  and dn.tzFlag = 209101 GROUP BY dn.shiptoNo,dn.shiptoName order by shiptoNo

| 648658| | 2022-11-30T11:55:00| false| | 2022-11-30T11:55:10.74| true| 這個能用 http://www.itpub.net/thread-1836567-1-1.html select dn.postDate from TBL_CRM_DELIVERYNOTE dn where dn.postDate >= trunc(to_date('2015-03', 'YYYY-| Anonymous|