Mam takie query:
SELECT tochar(dstamp, 'HH24') as HOUR, SUM(updateqty) as totalreceipt
FROM inventorytransaction
WHERE dstamp BETWEEN todate ('28/05/2021 18:00:00', 'dd/mm/yyyy hh24:mi:ss') AND
todate('29/05/2021 06:00:00',
SELECT tochar(dstamp, 'HH24') as HOUR, SUM(updateqty) as totalreceipt
FROM inventorytransaction
WHERE dstamp BETWEEN todate ('28/05/2021 18:00:00', 'dd/mm/yyyy hh24:mi:ss') AND
todate('29/05/2021 06:00:00',








źródło: comment_1623281291jmf6ZyaEQZNaCcwBNsvyoz.jpg
Pobierz