Thread: How can I convert an exported UNIX timestamp in excel?
View Single Post
  #1   Report Post  
prod sorter
 
Posts: n/a
Default How can I convert an exported UNIX timestamp in excel?
When I export a table using phpMyAdmin I get a date string of:

1064272434

Which equates to:

09/22/2003 07:13:54 PM

Is there a formula for excel that would make this conversion for me,
stripping the time of course?

Result:

09/22/2003

Reply With QuoteReply With Quote