PHP strtotime returns a 1970 date when date column is null

php date-format strtotime
Sandy505 picture Sandy505 · Oct 12, 2011 · Viewed 26k times · Source

I want to display $row->depositdate in dd-mm-yyyy format.

If the date column in database is null the date displayed is : 01-01-1970

echo "<td align=center>".date('d-m-Y', strtotime($row->depositdate))."</td>";

If the date is null in database it should display nothing , otherwise the date in dd-mm-yyyy format should be displayed.

Thanks in advance

Sandeep

Answer

GolezTrol picture GolezTrol · Oct 12, 2011

NULL is interpreted as 0 by strtotime, since it want to be passed an integer timestamp. A timestamp of 0 means 1-1-1970.

So you'll have to check for yourself if $row->depositdate === NULL, and if so, don't call strtotime at all.

Related questions

PHP Regex to check date is in YYYY-MM-DD format

I'm trying to check that dates entered by end users are in the YYYY-MM-DD. Regex has never been my strong point, I keep getting a false return value for the preg_match() I have setup. So I'm assuming I have …

Read More
How do I convert datetime to ISO 8601 in PHP

How do I convert my time from 2010-12-30 23:21:46 to ISO 8601 date format? (-_-;)

Read More
How to display a date as iso 8601 format with PHP

I'm trying to display a datetime from my MySQL database as an iso 8601 formated string with PHP but it's coming out wrong. 17 Oct 2008 is coming out as: 1969-12-31T18:33:28-06:00 which is clearly not correct (the year should be 2008 …

Read More