PHP Time/Date Cheatsheet

Side Note

I have a package to help with time/date manipulation which itself makes use of the brick/date-time package. If you need to do some complicated stuff, then I would recommend using these packages.

Converting User Input

$timestamp = strtotime("01/01/1999");
$timestamp = strtotime(915148800);
$timestamp = strtotime("1st January 1999");
Copy to clipboard

You now have the unix timestamp (number of seconds as an integer, since 1st January 1970)

PHP considers date strings with - to be English, and dates with / to be American.

# This is the the 2nd of Jan, not the 1st of Feb
$timestamp = strtotime("01/02/1999");

# This is the the 1st of Feb, not the 2nd of Jan
$timestamp = strtotime("01-02-1999");
Copy to clipboard

Since the timestamp is just an integer, you can print it or perform maths with it.

print $timestamp; // outputs 915148800

# one day later
$dayLater = $timestamp + (60 * 60 * 24);
Copy to clipboard

Converting To Human Form

Use the date() function to output in a human readable form. E.g.

// outputs Friday 1st January 1999
echo date('l jS F Y', $timestamp); 

// outputs 01-02-1999 (british)
echo date('d-m-Y', $timestamp);

// outputs 02/01/1999 (americans)
echo date('m/d/Y', $timestamp);

// The format for 23:01:01 would be:
echo date('H:i:s', $timestamp);

// For 12 hour fomat with leading 0s:
echo date('h:i:s', $timestamp);
Copy to clipboard

Be careful not to do this:

$timestamp = strtotime("2nd January 1999");
$humanTime = date('d/m/Y', $timestamp);
$newTimestamp = strtotime($humanTime);
// $timestamp !== $newTimestamp
Copy to clipboard

Form Input Type - Date

If you are using a date input field and pre-populating the value, you need to use code like this:

<input type="date" value='<?= date('Y-m-d', $unixTimestamp); ?>');
Copy to clipboard

Working With DateTime

If you need to create a DateTime object, then here are some useful snippets:

Create From Specified Date Format

$americanStyleDate = "12/31/2020";
$datetime = DateTime::createFromFormat('m/d/Y', $americanStyleDate);
Copy to clipboard

Create From MySQL Date

The MySQL date format is actually already in Y-m-d format, so one can just use it directly in the constructor like so:

$dateTime = new DateTime($mysqlDate);
Copy to clipboard

Convert DateTime To MySQL Format

$mysqlDate = $dateTime->format('Y-m-d');
Copy to clipboard

Working With Brick\DateTime

Create LocalDate From MySQL / PgSQL Date String

The following is a quick way to convert from a MySQL or PgSQL date string to a LocalDate object. This can easily be done because it is already in the format that the DateTime object expects

$localDate = \Brick\DateTime\LocalDate::fromNativeDateTime(new DateTime($dbRow['my_date_field']));
Copy to clipboard

Misc

Convert Time to Seconds

If you want to know how many seconds a time like 36 minutes past 9 AM is in seconds since midnight execute the following:

echo strtotime('09:36') - strtotime('TODAY');
Copy to clipboard

This is also the same as:

echo strtotime('09:36:00') - strtotime('TODAY');
Copy to clipboard

Getting Current MySQL Timestamp String

If you want to create the timstamp string and insert it rather than rely on MySQL creating the timestamp for you, then you can use this:

echo date('Y-m-d H:i:s', time());
Copy to clipboard

Update File Time

The following snippet will programmatically set a file to have been edited at a specific unix timestamp.

<?php

$filename = "test-php-file.txt"; // specify name for file to create/edit timestmap of
$timestamp = time() - (60*60); // set a unix timestamp here.
$dateString = date("d F Y H:i:s", $timestamp);
$cmd = "touch -d '{$dateString}' {$filename}";
shell_exec($cmd);
Copy to clipboard

References

• Stack Overflow - How to convert a "HH:MM:SS" string to seconds with PHP?
• phptutorial.net - PHP DateTime