→ is midnight (00:00:00 or 12:00:00 for 24-hour and 12-hour clock time, respectively). If you specify a … column are set to midnight. Otherwise, Oracle may not return the query results you expect. You can use … the TRUNC (date) function to set the time field to midnight, or you can include a greater-than or less …
Is the issue resolved?
Sorry I was so busy for since last Thursday...thank you for reply...this is too technical and I don't really know what to do. I will forward your reply to our programmer and let you know once I get a reply.