Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact
 
Python and Tcl - public course schedule [here]
Private courses on your site - see [here]
Please ask about maintenance training for Perl, PHP, Lua, etc
 
FileMaker Day to Unix Time conversion

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"!

(written 2015-02-15)

 
Associated topics are indexed as below, or enter http://melksh.am/nnnn for individual articles
H312 - PHP - Tips and Techniques
  [4621] The power of scripting - (2016-01-12)
  [4319] PHP - some quick fixes if scripts have issues, and how to use our support - (2014-11-19)
  [4310] Problem ... I want to print a series of numbered forms - (2014-10-05)
  [4074] A comment on comments in PHP - (2013-04-28)
  [2981] How to set up short and meaningfull alternative URLs - (2010-10-02)
  [2478] How did I do THAT? - (2009-10-26)
  [2274] PHP preg functions - examples and comparision - (2009-07-08)
  [2025] Injection Attack if register_globals in on - PHP - (2009-02-04)
  [1983] Keeping PHP code in database and running it - (2009-01-09)
  [1958] PHP - Parse error: syntax error, unexpected $end ... - (2008-12-23)
  [1684] Two PHP include files to make easy web site indexing and navigation - (2008-06-21)
  [1667] Checking server performance for PHP generated pages - (2008-06-06)
  [1649] Easy conversion - image formats, currencies and distances - (2008-05-21)
  [1270] PHP Standalone - keyboard to screen - (2007-07-18)
  [1010] Dates, times, clickable diarys in PHP - (2006-12-28)
  [917] Syntax checking in PHP - (2006-11-07)
  [789] Hot answers in PHP - (2006-07-02)

S154 - MySQL - Designing an SQL Database System
  [3494] Databases - when to treat the rules as guidelines - (2011-10-23)
  [3361] Blowing our own trumpet - MySQL resources - (2011-07-18)
  [3270] SQL - Data v Metadata, and the various stages of data selection - (2011-04-29)
  [2749] Delegate Question - defining MySQL table relationships as you create the tables - (2010-05-02)
  [2204] Images in a database? How big is a database? (MySQL) - (2009-05-28)
  [2085] MySQL - licensing issues, even with using the name - (2009-03-16)
  [2053] What a difference a MySQL Index made - (2009-02-25)
  [1771] More HowTo diagrams - MySQL, Tomcat and Java - (2008-08-24)
  [1575] Database design for a shopping application (MySQL) - (2008-03-15)
  [1423] MySQL - table design and initial testing example - (2007-11-06)
  [945] Code quality counts - (2006-11-26)
  [937] Display an image from a MySQL database in a web page via PHP - (2006-11-22)
  [918] Databases needn't be frightening, hard or expensive - (2006-11-08)
  [666] Database design - get it right from first principles - (2006-04-02)
  [515] MySQL - an FAQ - (2005-12-03)
  [494] MySQL - a score of things to remember - (2005-11-12)
  [375] Oops - I got my initial database design wrong - (2005-07-12)
  [361] Binary Large Objects or bars - (2005-06-27)
  [59] MySQL - Pivot tables - (2004-09-22)

G914 - Well House Consultants - Other Software
  [4303] Libre Office - unable to get past REOPEN WINDOWS? question - (2014-09-22)
  [4038] Using Pygments to colour our training examples - (2013-03-10)
  [3991] Email from Christopher Columbus to announce finding America? - (2013-01-29)
  [3896] An email marathon - (2012-10-15)
  [3648] iPad and iPhone programming - our seminar weekend with Xcode - (2012-03-11)
  [3599] Seeing how Melksham has changed over the years, via an iPad - (2012-01-30)
  [3584] QR codes - graphics images that provide quick phone links - (2012-01-18)
  [3213] Should I use Open Source or Commercial software? - (2011-03-26)
  [2906] Switching from Adobe Photoshop to Gimp - testing it on animals - (2010-08-06)
  [2600] Go Programming Language and Courses? - (2010-01-26)
  [2470] Windows 7 and Open Source Programming - (2009-10-22)
  [2191] RT @brento - a valuable source for the twitter newbie - (2009-05-20)
  [2106] Learning to Twitter / what is Twitter? - (2009-03-28)
  [75] It's just not cricket - (2004-10-06)


Back to
A Welsh valley - what the transport looks like in 2015
Previous and next
or
Horse's mouth home
Forward to
Java example - for loop and conditionals from course exercise
Some other Articles
The spirit of Java - delegating to classes
Wind Turbines - beauty or menace?
Using the lead - passing arrays and other collections in Java
Java example - for loop and conditionals from course exercise
FileMaker Day to Unix Time conversion
A Welsh valley - what the transport looks like in 2015
Looking Forward - TransWilts Community Rail Partnership and TransWilts CIC
Campus - about the logos / way marks you have been choosing from
Objects - from physical to virtual or abstract - Java
How healthy are the stars of stage and screen?
4759 posts, page by page
Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96 at 50 posts per page


This is a page archived from The Horse's Mouth at http://www.wellho.net/horse/ - the diary and writings of Graham Ellis. Every attempt was made to provide current information at the time the page was written, but things do move forward in our business - new software releases, price changes, new techniques. Please check back via our main site for current courses, prices, versions, etc - any mention of a price in "The Horse's Mouth" cannot be taken as an offer to supply at that price.

Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2019: 404 The Spa • Melksham, Wiltshire • United Kingdom • SN12 6QL
PH: 01225 708225 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/mouth/4426_Fil ... rsion.html • PAGE BUILT: Sat May 27 16:49:10 2017 • BUILD SYSTEM: WomanWithCat