Convert date (PHP)

Question

I am using JDF library for converting databases dates in my panel. My programming language is php and i am using while loop for show data. database date type is datetime.For example : 2018-07-21 11:14:19.678896

<?php
Include_once "jdf.php";
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $array = explode(' ', $row['date']);
    list($year, $month, $day) = explode('-', $array[0]);
    list($hour, $minute, $second) = explode(':', $array[1]);
    $timestamp = mktime($hour, $minute, $second, $month, $day, $year);
    date_default_timezone_set("Asia/Tehran");
    $converted_date = jdate("Y/m/d H:i:s", $timestamp);
    echo $row['full_name'] . ", reg date:" . $converted_date;
}

When i run code, Y/m/d become convert BUT for H:i:s just first row become convert. I really dont know why ...
Can you help me ?

Nick · Accepted Answer · 2018-12-01T07:25:37.877

0

It's probably simpler to use the inbuilt DateTime class to process your data:

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $date = date_create_from_format('Y-m-d H:i:s.u', $row['date'], new DateTimeZone('UTC'));
    $date->setTimeZone(new DateTimeZone('Asia/Tehran'));
    $converted_date = jdate('Y/m/d H:i:s', (int)$date->format('U'));
    echo $row['full_name'] . ", reg date:" . $converted_date;
}

Output:

2018/07/21 15:44:19

Demo on 3v4l.org

edited Dec 01 '18 at 07:25

answered Dec 01 '18 at 07:09

Nick

138,499
22
57
95

Thanks, But i wan to show my country date, i dont want for example 2018/07/21.want 1397/04/16. – O. Hebaby Dec 01 '18 at 07:17
so jdf library is for this work – O. Hebaby Dec 01 '18 at 07:17
@O.Hebaby My edited code will now call `jdate`, it uses `$date->format('U')` to get the timestamp from the adjusted date – Nick Dec 01 '18 at 07:20
output is : 1543046922 – O. Hebaby Dec 01 '18 at 07:24
Thanks its works But i dont know why in some rows it add 3:30 in other 5:30 and some times 2:30 – O. Hebaby Dec 01 '18 at 07:31
@O.Hebaby it is probably related to daylight savings time. The time difference between Tehran and UTC will change according to the time of year. Although it is strange that it could be `5:30` – Nick Dec 01 '18 at 07:34

Convert date (PHP)

1 Answers1