How to get current time in Datetime format PHP?

Question

I need to get current time in UTC to store in in datetime field(2019-08-17 00:00:00) type in MySQL.

How to get it in PHP?

I tried: now(); it gives me milliseconds

`format('U = Y-m-d H:i:s') . "\n"; $date->setTimestamp(1171502725); echo $date->format('U = Y-m-d H:i:s') . "\n"; ?> ` — Nipun Tharuksha, Aug 16 '19 at 09:26
https://stackoverflow.com/questions/9043719/php-datetimeformat — Diogo Santo, Aug 16 '19 at 09:42

Antonio Llamas · Accepted Answer · 2019-08-16T09:44:47.110

2

You should find info about the DateTime class to work with dates in php

$d = new DateTime('now');
$d->setTimezone(new DateTimeZone('UTC'));
echo $d->format('Y-m-d H:i:s');

edited Aug 16 '19 at 09:44

answered Aug 16 '19 at 09:30

Antonio Llamas

It gives me zero hours, minutes: 2019-08-17 00:00:00 – POV Aug 16 '19 at 09:32
try it again, I forgot ' . `echo $d->format('Y-m-d H:i:s');` This should work if the version of php you are using supports DateTime – Antonio Llamas Aug 16 '19 at 09:37
FYI, `'now`' is the default and you can also pass the time zone as second argument ([ref](https://www.php.net/manual/en/datetime.construct.php)). – Álvaro González Aug 16 '19 at 11:41

score 1 · Answer 2 · answered Aug 16 '19 at 09:42

1

You should try this.

date_default_timezone_set('UTC');
echo date('Y-m-d H:i:s');
// Output will be : 2019-08-16 09:41:24

answered Aug 16 '19 at 09:42

Bhavesh Patel

Arfandi Hatam · Answer 3 · 2019-08-16T10:10:21.467

0

try this code

$date=date_create(date("Y-m-d h:i:s"));
echo date_format($date,"Y-m-d H:i:s");
#output : 2019-08-16 09:49:20

edited Aug 16 '19 at 10:10

answered Aug 16 '19 at 09:48

Arfandi Hatam

This is a really convoluted way to do it, full of redundant from/to string conversions, but most importantly, it's incorrect because it doesn't take time zone into account. – Álvaro González Aug 16 '19 at 11:45

3 Answers3