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

[expired user #12072]'s profile image [expired user #12072] posted 5 years ago in General Permalink

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

1 attachment(s):
  • -
[expired user #8169]'s profile image [expired user #8169] posted 5 years ago Permalink

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, .... )

[expired user #12072]'s profile image [expired user #12072] posted 5 years ago Permalink

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.