How do I change the format of date + time in a database when calling it?
Currently it's:
YYYY-MM-DD Days:HH:MM
But I need it to be:
DD-MM-YYYY Days:HH:MM
I tried this approach
FORMAT(s.date, 'DD-MM-YYYY')
But it gives me something like this:
20,130,618,232,643
Because it has time included I think.