I need to use a datetime in a SQL query and it expects it in format 'yyyy-MM-dd 00:00:00'.
I have a string in format 'dd/MM/yyyy'.
How do I get the string formatted as the query wants it? I've tried parse and format but can't seem to get it right. Keep getting the error 'Invalid date/time: 4/10/2016 00:00:00 '.