Cimb posted

how to check , provided datetime value from database is valid date or not , in php ?

I am using datetime fieldType for loginDatetime field
but when person only registered and never loggedin .its remain 0000-00-00 00:00:00

and in backend i want to print at user list

i used following code


			$d=date('M j \'y H:i',strtotime($value->LogindateTime));

and its give me result as below



Jan 1 '70 00:00

Which is not expected, i am expecting it remain blank if people doesnot loggged in after registration

Edit Question

dilip
answered Nov 30 '-1 00:00

use following code


			if(strtotime($value->LogindateTime)>0){
 
			$d=date('M j \'y H:i',strtotime($value->LogindateTime));
			echo $d;
			}

strtotime return null or negative timestamp .if it 0000-00-00 00:00:00 so i think it will work

Edit Answer

Cimb posted

how to check , provided datetime value from database is valid date or not , in php ?

dilip answered Nov 30 '-1 00:00

Related Questions

Insert link

Insert image

dilip
answered Nov 30 '-1 00:00