date format: yyyy-mm-dd
MySQL:
SELECT CONVERT(varchar, getdate(), 23)
MSSQL:
SELECT DATE_FORMAT(curdate(), "%Y-%m-%d");
by Valeri Tandilashvili
4 years ago
MySQL
MySQL & MSSQL query differences
2
Pro tip: use ```triple backticks around text``` to write in code fences