I have 2 tables and, I want to create a join in SQL developer through the date times. Example, first table has a START\_DATETIME 3/28/1999 15:38:00 and second table has START\_DATETIME 3/28/1999 15:47:00, I want to join by date and hour only. Leaving out the min. How can I trunc the min to create a join between these tables. Please help.