"newformat"=>"m/d/Y",// or what you want
...
),
...
);
Make sure in your select (for MySQL) you do:
SELECT …. UNIX_TIMESTAMP(datefield) as datefield, …
This will convert your datefield into a UNIX (EPOCH) timestamp, however the problem is the column will now be called ‘UNIX_TIMESTAMP(datefield)’ so you need to do ‘as datefield’ to get its name back again so Guriddo can see the field.
The format I used is: "formatoptions"=>array("srcformat"=>"U","newformat"=>"d-M-Y H:i:s T")
This is quite nice as it removes the confusion between European and US style dates which are opposite to each other and causes problems with the day/month.
Additionally if you are using the date picker you will need to add/change:
.
