The challenge of the day was learning new php and mysql related terms involving a web design upgrade, and then finding a timestamp date and time code converter. The research began without knowing the right words to describe what was needed! It’s time to share the solution for novice designers facing the same mystery.

Searching the date and time code 1190073600 plus php or mysql, and then words like translate or convert, did not explain how that timestamp code translates to midnight on September 18, 2007. Knowing how to create similar dates and specific times in a proper 10 digit code was a variable necessary for importing updates to a searchable database being considered in a web design project.

Don’t even try to find a date or time in that code. 1190073600 is more cryptic than the 07 meaning 2007. The code 0000000000 translates to midnight on Thursday, January 1, 1970, 00:00:00 (GMT). That timestamp is the unix epoch, or reference date for unix based servers, and time is calculated in seconds from that “zero” time and date. Therefore, the mystery time code definition of 1190073600 is that moment in time 1,190,073,600 seconds after the unix epoch.

Noontime today when converted to a unix timestamp would be human readable as Thursday, November 5th 2009, 12:00:00 (GMT) and translates to 1257422400 as the unix timestamp. Without an understanding of how that 10 digit date and time code was created, it took persistent and stubborn research before finding this online timestamp (date and time) code converter.

With the solution and clearer terminology in hand, Google “standard time to unix online tool” and the first tool in search results today was this standard time and unix timestamp converter which converts the code or datetime either way. The linked 4webhelp.net version interface and display was nice, yet others in the top 10 results were adequate online tools, also.

Will I be disappointed if I can integrate and update the database without needing that date and time code converter? No. The solution was fun to research and will hopefully help others as curious or stubborn as me.