Breaking News: Grepper is joining You.com. Read the official announcement!

excel change date format php

Add Answer

kuldip ramdham answered on April 18, 2020 Popularity 8/10 Helpfulness 2/10

answer excel change date format php

related php change date format

related change date format php

related php change date format

excel change date format php

Comment

function correctDateTime($dateTime)
{
    # integer digits for Julian date
    $julDate = floor($dateTime);
    # The fractional digits for Julian Time
    $julTime = $dateTime - $julDate;
    # Converts to Timestamp
    $timeStamp = ($julDate > 0) ? ($julDate - 25569) * 86400 + $julTime * 86400 : $julTime * 86400;

   # php date function to convert local time
    return [
        "Date-Time"=>date("Y-m-d H:i:s", $timeStamp),
        "Date"=>date("Y-m-d", $timeStamp),
        "Time"=>date("H:i:s", $timeStamp)
    ];
}

$formattedValue = correctDateTime("44225.403368056");

echo $formattedValue["Date-Time"] . "\n";   // 2021-01-29 09:40:51
echo $formattedValue["Date"] . "\n";   // 2021-01-29
echo $formattedValue["Time"] . "\n";   // 09:40:51

Popularity 8/10 Helpfulness 2/10 Language php

Source: stackoverflow.com

Tags: date-format excel php

Link to this answer
Share Copy Link

Contributed on Dec 06 2022

kuldip ramdham

0 Answers Avg Quality 2/10

Closely Related Answers

php change date format

Comment

To convert the date-time format PHP provides strtotime() and date() function. We change the date format from one format to another.

Change YYYY-MM-DD to DD-MM-YYYY
<? php.
$currDate = "2020-04-18";
$changeDate = date("d-m-Y", strtotime($currDate));
echo "Changed date format is: ". $changeDate. " (MM-DD-YYYY)";
?>

Popularity 10/10 Helpfulness 10/10 Language php

Source: Grepper

Tags: date-format date

Link to this answer
Share Copy Link

Contributed on Apr 18 2020

Ankur

0 Answers Avg Quality 2/10

change date format php

Comment

$currDate = "2020-08-25";
$changeDate = date("d-m-Y", strtotime($currDate));
echo $changedDate;

Popularity 10/10 Helpfulness 6/10 Language php

Source: Grepper

Tags: date-format date

Link to this answer
Share Copy Link

Contributed on Aug 25 2020

Ankur

0 Answers Avg Quality 2/10

php change date format

Comment

<?php
  	#https://moneyconvert.net/
    $source = '2012-07-31';
    $date = new DateTime($source);
    echo $date->format('d.m.Y'); // 31.07.2012
    echo $date->format('d-m-Y'); // 31-07-2012
?>

Popularity 10/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: date-format date

Link to this answer
Share Copy Link

Contributed on Oct 28 2021

MONIN

0 Answers Avg Quality 2/10

php change date format

Comment

$dateString = '2022-12-31';
$dateTime = new DateTime($dateString);
$formattedDate = $dateTime->format('Y-m-d'); // Change the format code as per your needs
echo $formattedDate;

Popularity 7/10 Helpfulness 4/10 Language php

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

excel change date format php

Contents

More Related Answers

excel change date format php

Closely Related Answers

php change date format

change date format php

php change date format

php change date format

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.