Insert timestamp with milliseconds to Postgres table with PHP

Question

I have a Postgres table, like so:

create table test
    (
        time_stamp timestamp
    );

I want to generate a string with PHP that will insert the current time, with milliseconds (or microseconds) into the table.

Based on some other research, I've tried inserting the results of:

date('Y-m-d H:i:s.u', time())

But I'm only getting seconds. Any ideas?

RTFM: php.net/time it returns seconds. If you want milliseconds, then php.net/microtime but note that date() expects seconds as input anyways, so if you pass in a microtime, you're going to end up with some far-future time string, because it'll 1000000x bigger than what date()'s expecting. — Marc B
– Marc B, Commented Feb 4, 2016 at 19:26
Why not do it in SQL? insert into test (time_stamp) values (current_timestamp)? — user330315
– user330315, Commented Sep 9, 2021 at 9:24

Szymon · Accepted Answer · 2016-02-04 19:39:42Z

1

Or u can use date:

list($usec, $sec) = explode(' ', microtime()); 
$usec = str_replace("0.", ".", $usec);
print date('H:i:s', $sec) . $usec;

answered Feb 4, 2016 at 19:39

Szymon

1064 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alexander Emelianov · Accepted Answer · 2017-03-14 15:45:44Z

0

I had assumed there was an easy way to do this in PHP, but apparently there's not. Here's the solution:

function get_time() {
    $time = microtime(true);
    $micro_time = sprintf("%06d", ($time - floor($time)) * 1e6);
    return date('Y-m-d H:i:s.', $time).$micro_time;
}

edited Mar 14, 2017 at 15:45

Alexander Emelianov

5988 silver badges17 bronze badges

answered Feb 4, 2016 at 19:35

John Chrysostom

3,9931 gold badge43 silver badges56 bronze badges

Comments

Sérgio · Accepted Answer · 2021-09-09 09:17:52Z

0

I'm using date_create [1] from class datetime [2]

$dt1 = date_create();
echo $dt1->format('Y-m-d H:i:s.u');

2021-09-09 11:12:04.292321

[1] https://www.php.net/manual/en/function.date-create

[2] https://www.php.net/manual/en/class.datetime.php

answered Sep 9, 2021 at 9:17

Sérgio

7,3571 gold badge51 silver badges58 bronze badges

Collectives™ on Stack Overflow

Insert timestamp with milliseconds to Postgres table with PHP

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related