jasonrogena / jasonrogena/php-excel-reader
Date format Conversion problem
- Dominant language
- PHP
- Stars
- 1
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
```
I have upload the excel sheet to mysql database using the php excel reader
here i have problem with date format:
1. my date format in excel sheet 12/09/2011 (DD/MM/YYYY).
2. here i'm convert date in using
$variable=date('Y-m-d',strtotime($date_variable));
after the conversion
my date is 2011-12-09 (Y-m-d)
month is date is working wrong .
what will do now?
```
Original issue reported on code.google.com by `maniprak...@gmail.com` on 22 Sep 2011 at 6:47
Attachments:
- [example.php](https://storage.googleapis.com/google-code-attachments/php-excel-reader/issue-127/comment-0/example.php)
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reading the attached example.php and the PHP date conversion shown in the report, then trace how its output is passed to MySQL. Confirm the intended DD/MM/YYYY interpretation and that the stored value preserves the day and month; the report names no repository file or test to run.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, php
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100