date format

steve <[email protected]> Tue, 23 Mar 2010 12:33:42 +0100
Newsgroups gmane.comp.openoffice.dba.user
Message-ID <[email protected]>
Hi
When connecting to a mysql database, I have dates which show as:

1260351607

Is there any way I can convert them to DD/MM/YY format?
Clicking the field header and then choosing Column Format > Category > Date 
does not work. They are all converted to:
03/01/1

Thanks. Steve.