phpMyDataGrid Sample

DateTime type fields

Este ejemplo muestra la forma de usar campos datetime

This sample teach how to use datetime fields

Search by:

{"emp_id" : {"strfieldName" : "emp_id","strHeader" : "ID","fieldWidth" : "40","maxlength" : "50","columnwidth" : "93px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "1","ordering" : "1"},"active" : {"strfieldName" : "active","strHeader" : "Status","fieldWidth" : "13","maxlength" : "1","columnwidth" : "60px","align" : "left","mask" : "check:Inactive:Active","default" : "","select" : {0 : "Inactive",1 : "Active"},"cutChar" : "0","datatype" : "check","inputtype" : "0","ordering" : "1"},"fname" : {"strfieldName" : "fname","strHeader" : "Name","fieldWidth" : "13","maxlength" : "20","columnwidth" : "95px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "0","ordering" : "1"},"minit" : {"strfieldName" : "minit","strHeader" : "Middle Name","fieldWidth" : "5","maxlength" : "1","columnwidth" : "80px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "0","ordering" : "1"},"lname" : {"strfieldName" : "lname","strHeader" : "Last Name","fieldWidth" : "5","maxlength" : "30","columnwidth" : "95px","align" : "left","mask" : "text","default" : "","select" : "","cutChar" : "0","datatype" : "text","inputtype" : "0","ordering" : "1"},"birth_date" : {"strfieldName" : "birth_date","strHeader" : "Birth Date","fieldWidth" : "5","maxlength" : "10","columnwidth" : "105px","align" : "left","mask" : "date:mdy:-","default" : "","select" : "","cutChar" : "0","datatype" : "date","inputtype" : "0","ordering" : "1"},"hire_date" : {"strfieldName" : "hire_date","strHeader" : "Hire Date","fieldWidth" : "5","maxlength" : "19","columnwidth" : "195px","align" : "left","mask" : "datetime:mdy:-:His,:","default" : "","select" : "","cutChar" : "0","datatype" : "datetime","inputtype" : "0","ordering" : "1"}};

Company ABC, employees

New

	ID

	Status

	Name

	Middle Name

	Last Name

	Birth Date

	Hire Date

111124104

Active

lolow7

10-22-2020 20:10:15

111124059

Active

popo

wrwr

06-20-2019

12-27-2018 22:06:09

111124094

Active

lolo

03-31-2020 20:51:09

100340

Active

Alexander

XX,,,,k,k;

11-10-1971

03-14-2012 13:47:00

100341

Inactive

Mario

XXbnbvbn

03-10-1955

06-29-2005 20:24:00

2 3 4 ... 947 948 949 950

Displaying rows 1 to 5 of 4,748

NOTE: At this time the datetime type fields does not support datepicker function.
NOTA: En este momento, los campos datetime no aceptan el uso de la funci�n de calendario emergente.