Sorted it now.I'm getting confused with to_date and to_timestamp again.
Ahhhh.Thanks to anyone who looked at it anyway.