strtotime returning false date

stash_man Published at Dev

stash_man

I have a problem with strtotime function in php, i'm trying to convert mm-dd-yyyy to yyyy-mm-dd. The date is entered on the text box and on submit it should save the date to the database. the problem is it returns a wrong date(1970-01-01) each time,which means my code isn't taking the variable i use to store the date, My code is:

//dateconvert
$submitdate = date($_POST['date']);
$date   = date("Y-m-d", strtotime($submitdate));

//storeindb
$query ="INSERT INTO ticket SET date = '$date'";
$result = mysql_query($query);

I'm a newbie,please help.

Jonathon

Dates in the m/d/y or d-m-y formats are disambiguated by looking at the separator between the various components: if the separator is a slash (/), then the American m/d/y is assumed; whereas if the separator is a dash (-) or a dot (.), then the European d-m-y format is assumed.

http://php.net/manual/en/function.strtotime.php

You need to use the forward slash separator for mm/dd/yyyy formats.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-02-4

Comments

0 comments

From Dev

Related Related

Article

strtotime returning false date

strtotime returning false date

strtotime() function returning incorrect date

PHP date returning blank for Year "2090" with strtotime

strtotime return false while converting date string

Date formatting returning FALSE

Using strtotime() PHP and revert back trough gmdate() is not returning same date

strtotime('-1 month') returning wrong date if month have 31 days

PHP IF statement with Date not returning False

Jasmine date expect always returning false

Jasmine date expect always returning false

PHP date format and strtotime

PHP strtotime returning always midnight

Formating date string with strtotime and date

strtotime return false for certain dates

strtotime returns false on certain dates

PHP date conversion using strtotime

strtotime to time issue with a specific date

strtotime has issues because of date()

Formatting date using PHP strtotime

strtotime to time issue with a specific date

Check a date interval with strtotime in php

PHP strtotime returning the wrong result on calculation

strtotime always returning 1st january

PHP strtotime returning the wrong result on calculation

date strtotime() calculation returns 1969 date

strtotime doesn't return false with a valid timestamp

(PHP) strtotime function false positive with char

format of date string for strtotime() function in php

String date to time in PHP - strtotime "loses hours"

Must be a unixtime or a date/time representation parseable by strtotime