How to insert values into Postgresql column with datatype as double precision

Question

When I am trying to insert a date with timestamp to my postgresql table, I am getting the below error:

ERROR: invalid input syntax for type double precision: "2011-05-31 02:20:30"

The query is below. Here the ID field is a text and the REPORTED_DATE field is a double precision.

insert into my_table ("ID", "REPORTED_DATE")  values('ID8033','2011-05-31 02:20:30');

How do I need to change the query to be able to insert it ? Or do I need to change the datatype of the REPORTED_FIELD column accordingly ?

Jorge Hess · Accepted Answer · 2016-05-31 11:54:46Z

1

You need to change the datatype of REPORTED_FIELD, use timestamp, or change the string to get the time (seconds, milliseconds) of date and change the field to integer.

answered May 31, 2016 at 11:54

Jorge Hess

5502 silver badges9 bronze badges

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

1 Comment

H.Burns Over a year ago

thanks, it worked. I could solve it as :alter table my_table alter column "REPORTED_DATE" type timestamp with time zone using to_timestamp('REPORTED_DATE', 'YYYY-MM-DD HH24:MI:SS');

Julien Lopez · Accepted Answer · 2016-05-31 11:52:25Z

0

double precision is a floating-point number: https://www.postgresql.org/docs/9.5/static/datatype.html.

You are looking for timestamp: https://www.postgresql.org/docs/9.5/static/datatype-datetime.html

answered May 31, 2016 at 11:52

Julien Lopez

1,8645 gold badges21 silver badges26 bronze badges

Collectives™ on Stack Overflow

How to insert values into Postgresql column with datatype as double precision

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related