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
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With