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:

Related Tags for Php Sql Timestamp:

«Previous Index Next»

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics