Changing date format from yyyy-mm-dd to dd/mm/yyyy
Posted by: Bill Elton (---.opera-mini.net)
Date: October 20, 2014 03:57PM

I have entered date data in a table I created in this format dd/mm/yyyy but when I select * from said table the date is coming out in this format yyyy-mm-dd how can I fix/edit this so it comes out as dd/mm/yyyy? Its for an assignment due tomorrow so I need help ASAP. Thank you in advance

Options: ReplyQuote
Re: Changing date format from yyyy-mm-dd to dd/mm/yyyy
Posted by: RiggsFolly (---.dynamic.dsl.as9105.com)
Date: October 20, 2014 04:12PM

Can you answer these questions first so we know where you are coming from please. [forum.wampserver.com]



How did you enter the date?
Using PHP or
Something like phpMyAdmin

How are you retrieving this date?
Using PHP or
Something like phpMyAdmin

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote


Sorry, only registered users may post in this forum.