Timestamp: Difference between revisions From Online Manual

Jump to: navigation, search
(Created page with "A timestamp is a way of representing times in programming languages. Usually, this is a unix timestamp, expressed as the number of seconds since midnight on December 31, 1969. As...")
 
No edit summary
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
A timestamp is a way of representing times in programming languages. Usually, this is a unix timestamp, expressed as the number of seconds since midnight on December 31, 1969. As an example, the timestamp of January 1, 2006 at 12:00:00 am is 1136102400.
A timestamp is a way of representing times in programming languages. Usually, this is a unix timestamp, expressed as the number of seconds since midnight on December 31, 1969. As an example, the timestamp of January 1, 2006 at 12:00:00 am is 1136102400.


In MySQL, you can easily work with this by using the UNIX_TIMESTAMP() and FROM_UNIXTIME() functions, which translate between dates as strings and dates as timestamps. Examples include:
<noinclude>
{{Code|1=
[[Category:SMF terminology]]
SELECT UNIX_TIMESTAMP('2006-01-01 0:00:00');
</noinclude>
SELECT FROM_UNIXTIME(1136102400);
INSERT INTO smf_members
(memberName, realName, emailAddress, dateRegistered, passwd)
VALUES ('member', 'member', '[email protected]', UNIX_TIMESTAMP(NOW()),
MD5('password'));
}}
 
In PHP, you can work with them by using the time(), strftime(), and strtotime() functions.
 
<noinclude>[[Category:SMF Terminology]]</noinclude>

Latest revision as of 20:21, 8 July 2013

A timestamp is a way of representing times in programming languages. Usually, this is a unix timestamp, expressed as the number of seconds since midnight on December 31, 1969. As an example, the timestamp of January 1, 2006 at 12:00:00 am is 1136102400.

Retrieved from "https://wiki.simplemachines.org/w/index.php?title=Timestamp&oldid=17308"


Advertisement: