Home Sql Sql-functions PHP SQL Timestamp
Questions:Ask|Latest

 
 

Share on Google+Share on Google+

PHP SQL Timestamp

Advertisement
Creating a TimeStamp type column using PHP.

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(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

Output:

 

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: March 31, 2005

Related Tutorials

Ask Questions?    Discuss: PHP SQL Timestamp  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com