Main Content
FileMaker Day to Unix Time conversion Archive - Originally posted on "The Horse's Mouth" - 2015-02-15 13:57:45 - Graham Ellis
Posting here out of self defence ... this is always one I forget and it doesn't seem to come up on the searches. Coded in PHP.
# 735540 3/11/2014
$timeoffset = 735540 - mktime(12,0,0,11,3,2014) / 3600 / 24;
$daychanged = ($_REQUEST[whichday] - $timeoffset);
$report = date("D jS M Y",$daychanged * 3600 * 24);
Very inefficient, but converts a day number from the FileMaker data I have into a Unix TimeStamp, which I have then formatted to report on Day. Month and Year (and day of week too) in my output.
My users far prefer "3rd November 2014" to "735540"!
Some other articles
G914 - Other Software This article Libre Office - unable to get past REOPEN WINDOWS? question Using Pygments to colour our training examples Email from Christopher Columbus to announce finding America? An email marathon iPad and iPhone programming - our seminar weekend with Xcode Seeing how Melksham has changed over the years, via an iPad QR codes - graphics images that provide quick phone links Should I use Open Source or Commercial software? Switching from Adobe Photoshop to Gimp - testing it on animals Go Programming Language and Courses? Windows 7 and Open Source Programming RT @brento - a valuable source for the twitter newbie Learning to Twitter / what is Twitter? It's just not cricket S154 - Designing an SQL Database System This article Databases - when to treat the rules as guidelines Blowing our own trumpet - MySQL resources SQL - Data v Metadata, and the various stages of data selection Delegate Question - defining MySQL table relationships as you create the tables Images in a database? How big is a database? (MySQL) MySQL - licensing issues, even with using the name What a difference a MySQL Index made More HowTo diagrams - MySQL, Tomcat and Java Database design for a shopping application (MySQL) MySQL - table design and initial testing example Code quality counts Display an image from a MySQL database in a web page via PHP Databases needn't be frightening, hard or expensive Database design - get it right from first principles MySQL - an FAQ MySQL - a score of things to remember Oops - I got my initial database design wrong Binary Large Objects or bars MySQL - Pivot tables H312 - Tips and Techniques The power of scripting This article PHP - some quick fixes if scripts have issues, and how to use our support Problem ... I want to print a series of numbered forms A comment on comments in PHP How to set up short and meaningfull alternative URLs How did I do THAT? PHP preg functions - examples and comparision Injection Attack if register_globals in on - PHP Keeping PHP code in database and running it PHP - Parse error: syntax error, unexpected $end ... Two PHP include files to make easy web site indexing and navigation Checking server performance for PHP generated pages Easy conversion - image formats, currencies and distances PHP Standalone - keyboard to screen Dates, times, clickable diarys in PHP Syntax checking in PHP Hot answers in PHP