SirInsky
Member
Hello everyone,
need help with this query.
SELECT ABALPH AS Kunde, SDLITM AS Artikel, SDDSC1 AS Beschreibung, SDSOQS AS Menge, date(digits(decimal(SDIVD+1900000,7,0))) AS Invoice, decimal(SDUPRC/10000,15,2) AS Einzelpreis, decimal(SDAEXP/100,15,2) AS Gesamtpreis,
SDDOCO AS Dokument, AIAC01 AS Region
FROM ALCATRAZ.PRODDTA.F42119 F42119, ALCATRAZ.PRODDTA.F0101 F0101, ALCATRAZ.PRODDTA.F03012 F03012
Now my question is , how can I get the today date minus 1 day ?
Thank you so much
need help with this query.
SELECT ABALPH AS Kunde, SDLITM AS Artikel, SDDSC1 AS Beschreibung, SDSOQS AS Menge, date(digits(decimal(SDIVD+1900000,7,0))) AS Invoice, decimal(SDUPRC/10000,15,2) AS Einzelpreis, decimal(SDAEXP/100,15,2) AS Gesamtpreis,
SDDOCO AS Dokument, AIAC01 AS Region
FROM ALCATRAZ.PRODDTA.F42119 F42119, ALCATRAZ.PRODDTA.F0101 F0101, ALCATRAZ.PRODDTA.F03012 F03012
Now my question is , how can I get the today date minus 1 day ?
Thank you so much