I have a timestamp column (yyyy-mm-dd hh:mi:ss), and I need to join it to a normal date field in another table. How do I convert that timestamp to a date format in order to join it?