xxxxxxxxxx
date_default_timezone_set('asia/karachi'); // set timezone
$timestamp = $row['last_login']; // get current epoch time
$format = "Y-m-d h:i:s a"; // format for date output
$formatted_date = date($format, $timestamp); // convert timestamp to format
print($formatted_date);
xxxxxxxxxx
<?php
// To change the format of an existing date
$old_date_format = "20/03/1999";
$new_data_format = date("Y-m-d H:i:s", strtotime($old_date_format));
xxxxxxxxxx
<?php
$date = DateTime::createFromFormat('j-M-Y', '15-Feb-2009');
echo $date->format('Y-m-d');
?>
xxxxxxxxxx
date("D M j G:i:s T Y")."<br>"; // Sat Mar 22 17:16:18 MST 2001
date('H:m:s \m \i\s\ \m\o\n\t\h')."<br>"; // 18:03:18 m is month
date("H:i:s")."<br>"; // 18:16:18
date("Y-m-d H:i:s")."<br>"; // 2022-03-11 18:16:18 (MySQL DATETIME format)
date("j F, Y, g:i a")."<br>"; // 11 March, 2022, 6:16 pm
date("m.d.y")."<br>"; // 03.11.01
date("j, n, Y")."<br>"; // 11, 3, 2001
date("Ymd")."<br>"; // 20010310
date('h-i-s, j-m-y, it is w Day')."<br>"; // 02-12-18, 10-03-01, 1631 1618 6 Satpm01
date('\i\t \i\s \t\h\e jS \d\a\y.')."<br>"; // it is the 15th day.
xxxxxxxxxx
$myDateTime = DateTime::createFromFormat('Y-m-d', $dateString);
$newDateString = $myDateTime->format('d-m-Y');
xxxxxxxxxx
<?php
$date = '05/05/2021';
echo DateTime::createFromFormat("d/m/Y", $date)->format('Y-m-d');
//2021-05-05
xxxxxxxxxx
<?php
// Assuming you have established a MySQL database connection
// Query to retrieve the current date and time from MySQL
$query = "SELECT NOW() AS current_datetime";
$result = mysqli_query($connection, $query);
// Check if the query was successful
if ($result) {
// Fetch the result row
$row = mysqli_fetch_assoc($result);
// Retrieve the current datetime
$datetime = $row['current_datetime'];
// Format the datetime as desired (e.g., "Y-m-d H:i:s")
$formattedDatetime = date('Y-m-d H:i:s', strtotime($datetime));
// Output the formatted datetime
echo "Formatted Datetime: " . $formattedDatetime;
} else {
// Handle query error
echo "An error occurred.";
}
// Remember to close the database connection when you're done
mysqli_close($connection);
?>
xxxxxxxxxx
$fecha_format = date("d/m/Y", strtotime('2022-12-24'));
// salida: 24/12/2022