PHP SQL Timestamp
This example illustrates how to create a timestamp type column.
In this example the PHP date() function formats a timestamp to a more
readable date and time. A timestamp is the number of seconds since January 1,
1970 at 00:00:00 GMT. This is also known as the Unix Timestamp.
The first parameter in the date() function specifies how to format the
date/time. It uses letters to represent date and time formats. Here are some of
the letters that can be used:
- d - The day of the month (01-31)
- m - The current month, as a number (01-12)
- Y - The current year in four digits
The second parameter in the date() function specifies a timestamp. This
parameter is optional. If you do not supply a timestamp, the current time will
be used. In the mktime() function we create a timestamp for tomorrow. The mktime()
function returns the Unix timestamp for a specified date.
Source Code of timestamp.php
<?php
error_reporting(0);
echo date("Y/m/d");
echo "<br>";
echo date("Y.m.d");
echo "<br>";
echo date("Y-m-d");
mktime(hour, minute, second, month, day, year);
$tomorrow = mktime(0, 0, 0, date("m"), date("d")+1, date("Y"));
echo "Tomorrow is ".date("Y/m/d", $tomorrow)."<br><br>";
// time() return current timestamp------
$nextWeek = time() + (7 * 24 * 60 * 60);
echo 'Now: '. date('Y-m-d') ."<br>";
echo 'Next Week: '. date('Y-m-d', $nextWeek) ."<br>";
echo 'Next Week: '. date('Y/m/d', strtotime('+1 week'));
?>
|
Download Source Code
Output:
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
