RE: SQL time stamp starting beginning of yesterday

Ok I tried to insert you select into my statement but it is not working. How would I incorporate your select into mine?

SELECT *
FROM PROD/tlog
WHERE ttmpstmp > (select timestamp(current_date - 1 day)
from sysibm/sysdummy1)
AND tstep > 2
AND tsystem = 'XXXXXXXX'
GROUP BY tcntnbr



Chris Bipes
Director of Information Services
CrossCheck, Inc.


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Tuesday, May 09, 2017 9:25 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: SQL time stamp starting beginning of yesterday

select timestamp(current_date - 1 day)
from sysibm.sysdummy1

Is better choice, indexes over your timestamp field would be used.

Charles