mysql-date

DROP VIEW DNSOQTY;
CREATE VIEW DNSOQTY AS
SELECT SOBODY.*,SALES_ORDER_INV_DESCQTY-if(isnull(DNOTEQTY),0,DNOTEQTY) AS QTY 
,if(isnull(ALL_ADDRESS_BOOK.NAME),SOBODY.deliveryContactName,ALL_ADDRESS_BOOK.NAME)  SHIP_TO_CONTACT
,SOBODY.deliveryAddress SHIP_TO_ADDRESS 
,SOBODY.QD_NO OUR_REF_NO
,SOBODY.shipToCompany COMPANY_NAME
,'' AS COMMENT
,'' AS SERIAL_NUMBER
,CURRENT_DATE AS ACTIVE_DATE
,(CURDATE()+INTERVAL SOBODY.IV_MMTHS MONTH) - INTERVAL 1 DAY as EXPIRE_DATE
,ifnull(SALES_ORDER_PO_DESC.QTY,0) POQTY
,ifnull(SALES_ORDER_PO_DESC.GRNQTY,0) GRNQTY
FROM SOBODY
LEFT JOIN ALL_ADDRESS_BOOK ON ALL_ADDRESS_BOOK.RECORDID= SOBODY.deliveryContactName
LEFT JOIN SALES_ORDER_PO_DESC ON SALES_ORDER_PO_DESC.PARENT_RECORDID=SOBODY.SOH_RECORDID AND SALES_ORDER_PO_DESC.PRODUCT_RECORDID=SOBODY.PRODUCT_RECORDID
;




select surname,
sum(if(month(curdate())+year(curdate())*12-mth+year*12=1,netpay, 0)) as last1,
sum(if(4-mth=2,netpay,0)),sum(if(4-mth=1,netpay,0))
from payroll group by surname;

where=where (status:`A`   or status:`D`   or status:`C`  or status:`S` or status:`R` or status:`P`) and PO_DDATE<:ADDDATE(curdate(), INTERVAL '+7+' DAY)
formConstrain=and (status:`A`   or status:`D`  or status:`C`  or status:`S` or status:`R`  or status:`P`)  and PO_DDATE<:ADDDATE(curdate(), INTERVAL '+7+' DAY)


Date to mill seconds
select unix_timestamp(date)*1000 from history;



 select date(timestamp)>'20150130',TIMESTAMP from DNOTE_HEADER;