SQL join on date

From: Blue <sxr_at__nospam_hotmail.com>
Date: Thu, 29 Jul 1999 14:04:19 GMT
Message-ID: <37a15dc4.18034392@news.optusnet.com.au>

I would like to join two tables by a date field..

The first table always has a date plus a time value in the date field.

The second table always has a just a date value, time is always 0

What is the best SQL join statement to link them based on the date value only, ignoring time

Sorry if this is a stupid question but Oracle through impromptu locks up if I use a function to convert the date-time to a date.

Blue Received on Thu Jul 29 1999 - 09:04:19 CDT