TimeStamp error + postgresql + node.js

Question

I have a value for time as 2017-05-25T18:44:56 . The following is my table structure

CREATE TABLE aaaaaa (
    enroll_id bigserial primary key,
    time timestamp with time zone NOT NULL        
);

When i insert the above value into time column its throws the following error { error: syntax error at or near "T18"}

How can i solve this? Please share your ideas. Thanks in advance.

My insert Query:

var query = 'Insert Into aaaaa (enroll_id, time,) values ('+item.EnrollNumber+', '+item.time+')';

Its saying syntax error in your query. Share your insert query here. — Durgpal Singh, Jul 27 '17 at 07:27
I've successfully inserted the value into the table, so it is not postgresql fault. You can always cast value to timestamp. — Lemjur, Jul 27 '17 at 07:28
You should never concatenate queries manually, you're supposed to use the driver to escape all the values. — vitaly-t, Jul 27 '17 at 10:00

Lemjur · Accepted Answer · 2017-07-27T07:42:59.957

0

You have to surround time value with quotes.

Insert Into aaaa (enroll_id, time) values (19, '2017-05-25T18:44:56')

and query construction in javascript should look similiar to

var a=15;
var b='2017-05-25T18:44:56';
var query = "Insert Into aaaaa (enroll_id, time,) values ("+a+", '"+b+"')";

edited Jul 27 '17 at 07:42

answered Jul 27 '17 at 07:30

Lemjur

im constructin query like this `var query = 'Insert Into aaaaa (enroll_id, time,) values ('+item.EnrollNumber+', '+item.time+')';` How can i modify this to form the above query – Subburaj Jul 27 '17 at 07:34

1 Answers1