Page 1 of 1

UK Date Format with Timestamps

PostPosted: Thu Jan 03, 2013 6:12 am
by ngms27
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?

Re: UK Date Format with Timestamps

PostPosted: Mon Jan 07, 2013 10:30 pm
by wqeqwe
vxcvxcd

Re: UK Date Format with Timestamps

PostPosted: Tue Jan 08, 2013 8:26 am
by ngms27
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')));
}
}
?>