Ads were blocked by your webbrowser.

This is not a problem, but keep in mind that developing HeidiSQL, user support and hosting takes time and money.

You may want to send a donation instead.

How to change date format YYYY-MM_DD to DD-MM-YYYY?

noxioustoo's profile image noxioustoo posted 6 months ago in General

I need to change date format in some table. Not select changed data! Thank you in advance.

1 attachment(s):
  • -
deneth's profile image deneth posted 5 months ago

date are stored with this format ( YYYY-MM-DD ) in the database, you can't change this.

If you need to display or use a date in other format, your app/webpage/what evre you use must manage the change. There is date fonction in every programming language ( sql, php, python, .... )

noxioustoo's profile image noxioustoo posted 5 months ago

date are stored with this format ( YYYY-MM-DD ) in the database, you can't change this.

If you need to display or use a date in other format, your app/webpage/what evre you use must manage the change. There is date fonction in every programming language ( sql, php, python, .... )

Thank you.

Please login to leave a reply, or register at first.