Get the current date and time in PHP with '2016-07-04 00:00:00.000' format

Question

I am using mssql db with php. Which PHP function can return the current datetime. (i.e.) I want the current date and time to be saved in the following format say for example,

2016-07-04 11:10:05.000

Thanks!

Something like this: `echo substr(date("Y-m-d H:i:s.u", time()),0,-3);` — Thamilhan, Jul 04 '16 at 12:31

score 5 · Accepted Answer · answered Jul 04 '16 at 12:26

5

Use date->format http://php.net/manual/it/function.date.php

$date = new DateTime('2000-01-01');
echo $date->format('Y-m-d H:i:s.u');

answered Jul 04 '16 at 12:26

ScaisEdge

131,976
10
91
107

echo date('Y-m-d H:i:s'); is enough..? – Deepak Keynes Jul 04 '16 at 12:40
if you want miilsecond you need "Y-m-d H:i:s.u" if you want ever 0000 you can use "Y-m-d H:i:s.0000" ... if you want only second "Y-m-d H:i:s" you obtain 2016-07-04 11:10:05 – ScaisEdge Jul 04 '16 at 12:54
yes i got it. Thanks for sharing.. – Deepak Keynes Jul 04 '16 at 13:09

Fabio Widmer · Answer 2 · 2016-07-04T12:31:36.650

1

With "date" you can format the output and with "time" you get the current unix time.

Example

echo date("Y-m-d H:i:s.u", time());

Documentation: http://php.net/manual/it/function.date.php

edited Jul 04 '16 at 12:31

answered Jul 04 '16 at 12:25

Fabio Widmer

529
1
7
19

score 1 · Answer 3 · answered Jul 04 '16 at 12:28

1

12-hour format

date("Y-m-d h:i:s.u")

24-hour format

date("Y-m-d H:i:s.u")

answered Jul 04 '16 at 12:28

Tariq Yousef

41
5

Get the current date and time in PHP with '2016-07-04 00:00:00.000' format

3 Answers3