UK Date Format with Timestamps

Archived from the Xataface Users forum.

ngms27 — Thu Jan 03, 2013 6:12 am

I’m using the timestamp option in several databases which is fine for the backend data.
However I’m in the UK as as always Xataface defaults to the US date/time format.

How can I switch my timestamp fields to display UK date and time such as dd/mm/yyyy hh:mm:ss

Would a change affect filtering and sorting?

---

wqeqwe — Mon Jan 07, 2013 10:30 pm

vxcvxcd

---

ngms27 — Tue Jan 08, 2013 8:26 am

I managed to fix this using:

<?php
class tables_projects {
function lastmodified__display(&$record){
return date(‘d/m/Y H:i:s’, strtotime($record->strval(‘lastmodified’)));
}
}
?>