At 15:23 -0500 2006/04/06, David Wolverton wrote:
I had this select statement run right at the midnight break...
SELECT.STATEMENT = 'SELECT TSE USING D.TSE WITH ACT.BATCH.STATUS = EXTCOMP
AND WITH COMPLETED # COMP OR WITH CALL.IN.DATE LE
':OCONV(DATE(),'D4/'):' AND WITH CALL.IN.TIME LE
Hello, David.
The TIMEDATE() function result is coherent. You just need to separate the
date from the time.
Best regards,
Gyle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/