Re: [U2] Speaking of TIME...

2006-04-07 Thread Raymond DeGennaro II
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

RE: [U2] Speaking of TIME...

2006-04-07 Thread Gyle Iverson
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/