I am loading data from a data warehouse. I have are dates and some which are times. The times ones are fine but the date fields are loadign as dd/mm/yyyy hh:mm. As I already have a separate time field I don't require that portion of this field. Is there a simple way to correct this in the load statement.?