jasonrogena / jasonrogena/php-excel-reader

Date format Conversion problem

Open
#127 0 comments 0 reactions 0 assignees View on GitHub
auto-migrated Priority-Medium Type-Defect
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.