How to join two tables while one is using Date and another is using Timestamp on Oracle, for example, select * from Orders o, AuditLog a where o.TradeDate = a.EventTs Orders ======= TradeDate (Date) e.g. 14-JUN-08 AuditLog ========= EventTs (Timestamp) e.g. 12-JUN-08 10.28.53.083000000 AM Thanks! Regards
