datetime is giving empty value in update and insert

Questions › datetime is giving empty value in update and insert

anita yadav asked 4 years ago

Hi Team,

I have used datetime formatter to view/add/update the mysql datatype column in grid, but it is inserting/updating with empty value in datatime mysql table.

I have used code like below:-$col = array();
$col[“title”] = ‘DttmUploaded’;
$col[“name”] = ‘DttmUploaded’;
$col[“width”] = “180”;
$col[“editable”] = true;
$col[“formatter”] = “datetime”;
$col[“editoptions”] = array(“size”=>20, “value”=>date(‘Y-m-d H:i:s’));
$col[“formatoptions”] = array(“srcformat”=>’Y-m-d h:i:s’,”newformat”=>’m-d-Y h:i:s’);
$cols[] = $col;

but while insert it gives following insert query

INSERT INTO `businessentity` (`Id`, `FileRecordId`, `IsProcessed`, `CreatedDate`, `DttmSubmitted`, `ImportedBy`, BusinessEntityNumber,Name,Priority,ParentBeNumber,RecapClockType `,DttmUploaded`) VALUES (NULL, ‘-1’, ‘0’, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, ‘204’ ,’dcsd’,’dsf’,’1′,’3′,’3′,”)

Do i need to do anything else, to get the value.

Could you plz help me. I have stuck into this.

Thanks and Regards