How to join two tables while one is using Date and another is using Timestamp?
From: Mullin Yu <mullin.yu_at_gmail.com>
Date: Thu, 12 Jun 2008 04:06:03 -0700 (PDT)
Message-ID: <8a84044f-5b5a-4d70-b39b-d35470ba004a@w1g2000prd.googlegroups.com>
TradeDate (Date)
e.g. 14-JUN-08
EventTs (Timestamp)
e.g. 12-JUN-08 10.28.53.083000000 AM
Date: Thu, 12 Jun 2008 04:06:03 -0700 (PDT)
Message-ID: <8a84044f-5b5a-4d70-b39b-d35470ba004a@w1g2000prd.googlegroups.com>
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 Received on Thu Jun 12 2008 - 06:06:03 CDT