Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact
 
For 2023 (and 2024 ...) - we are now fully retired from IT training.
We have made many, many friends over 25 years of teaching about Python, Tcl, Perl, PHP, Lua, Java, C and C++ - and MySQL, Linux and Solaris/SunOS too. Our training notes are now very much out of date, but due to upward compatability most of our examples remain operational and even relevant ad you are welcome to make us if them "as seen" and at your own risk.

Lisa and I (Graham) now live in what was our training centre in Melksham - happy to meet with former delegates here - but do check ahead before coming round. We are far from inactive - rather, enjoying the times that we are retired but still healthy enough in mind and body to be active!

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

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

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


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., 2024: 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/mouth/4426_Fil ... rsion.html • PAGE BUILT: Sun Oct 11 16:07:41 2020 • BUILD SYSTEM: JelliaJamb