Insert server time to Postgres DB

ghjk

I want to insert current server time to the postgres database. Data type is timestamp. When I insert the date, got an error saying

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type timestamp: "1246960321" in C:\Program Files\xampp\htdocs\xxx\xxx\xxx.php on line 57
Error in SQL query: ERROR: invalid input syntax for type timestamp: "1246960321"

I take the time as follows.

Expand|Select|Wrap|Line Numbers

$today = strtotime("now");

Please help me..

Dormilich

wouldn't it be easier in this case to use the SQL function NOW()?

Expand|Select|Wrap|Line Numbers

INSERT INTO ... VALUES ( NOW() )

edit: do you pass the timestamp as string or integer value?

Insert server time to Postgres DB

re: Insert server time to Postgres DB

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about