I would like to insert the date as in the dd-mm-yyyy format in sql, can anyone suggest me the syntax
-
-
You don't store dates in the database according to a certain format. Date formats are only important to users when you display the date to them or when they capture a date on some screen. In that case you would format the date according to their preferences (typically locale).
If you have text then you can convert it to a date using the STR_TO_DATE function.
Comment