Skip to Content
1
Former Member
Jun 08, 2016 at 11:17 AM

HANA Alert Query

540 Views

Hi All,

I have made one query in SQL for Sales order creation. means whenever sales order will be add into the system one notification should be popup. "

SELECT T0.DocNum, T0.CardCode, T0.Cardname, T0.DocDate, T0.DocTotal FROM ORDR T0 WHERE T0.DocStatus ='O' AND CONVERT(char(8),T0.CreateDate,112) = CONVERT(char(8), GETDATE(),112)

Now the same query I am writing in HANA but It is not working. Please help me to get the right result.

SELECT T0."DocNum", T0."CardCode", T0."Cardname", T0."DocDate", T0."DocTotal FROM ORDR T0 WHERE T0."DocStatus" ='O' AND CONVERT(char(8),T0.CreateDate,112) = CONVERT(char(8), GETDATE(),112)

Thanks

A Ali