How to join two tables while one is using Date and another is using

by Mullin Yu <mullin.yu@[EMAIL PROTECTED] > Jun 12, 2008 at 04:06 AM

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

6 Posts in Topic:

How to join two tables while one is using Date and another is us

Mullin Yu <mullin.yu@[

2008-06-12 04:06:03

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

steph <stephan0h@[EMAI

2008-06-12 05:26:34

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

Walt <walt_askier@[EMA

2008-06-12 16:20:16

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

Mladen Gogala <mgogala