How to join two tables while one is using Date and another is using Timestamp?
Date: Thu, 12 Jun 2008 04:06:03 -0700 (PDT)
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
e.g. 12-JUN-08 10.28.53.083000000 AM
Regards Received on Thu Jun 12 2008 - 06:06:03 CDT