Adsense
Popular Posts
- Code update from PHP 7.4 to PHP 8.1 - PhpSpreadsheet
- MySQL workbench -"Could not decrypt password cache"
- Code update from PHP 7.4 to PHP 8.1 - Worksheet/Iterator.php
- Rendering HTML tags inside textarea
- axios handle blob type data
- Unix Utils and wget in Windows
- increase mysql query speed
- Setup vi syntax for PHP
- EXCEL return to the next line in the same cell
- Get WAMP running on EC2
Tuesday, June 17, 2014
FileMaker and EXCEL date format to MySQL
I export Filemaker database to EXCEL (.csv) and upload it MySQL in PHPMyadmin.
The date format in Filemaker and EXCEL is: dd/mm/YYYY,
while in mySQL: YYYY-mm-dd
It is difficult to change date format in Filemaker to MySQL.
It is easier to change the date format in EXCEL
1) Right click date column in EXCEL, go to Format Cells and then the Number tab.
2) Select Date
3)Change the Locale to English (U.K.), default is English (USA) and you can not find MySQL date format
4) The fifth item on the list 2001-03-14 is the format for MySQL.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment