PHP SQL Timestamp

Creating a TimeStamp type column using PHP.

PHP SQL Timestamp

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 


  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(000, date("m"), date("d")+1, date("Y"));
  echo "Tomorrow is ".date("Y/m/d", $tomorrow)."<br><br>";
  // time() return current timestamp------
  $nextWeek = time() (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