Re: How to join two tables while one is using Date and another is using Timestamp?

On 12 Jun., 13:06, Mullin Yu <mullin..._at_gmail.com> wrote:
> 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

by removing the time component of the time stamp like:

select * from Orders o, AuditLog a
where o.TradeDate = trunc(a.EventTs) Received on Thu Jun 12 2008 - 07:26:34 CDT