如何使用php在postgresql表中插入timestampz值

Question

We have one 2 field in of type 'timestampz' like createdon & updatedon

createdon field is inserted using 'Now()' function of postgresql.

and i need to insert updatedon field by using php. like i try to insert using 'date( 'Y-m-d H:i:s' , $timestamp );'.

When i try to get updated field is gives me wrong result.

I want to know i want to insert timestampz using php how i can to that.

Answer 1

Can't you do something like "UPDATE table SET ..., updatedon = NOW() WHERE ..."?