PostgreSQL timestamp select

Question

I'm using Posture and I got error message "invalid input syntax for type timestamp with time zone" when using the following select code:

SELECT * FROM public."table1" WHERE 'registrationTimestamp' BETWEEN 
to_timestamp('22-10-2013 00:00', 'DD-MM-YYYY HH24:MI')
AND to_timestamp('22-10-2013 23:59', 'DD-MM-YYYY HH24:MI')**

While registrationTimestamp timestamp format is like following:

6/26/2012  6:43:10 PM

if registrationTimestamp is a column, it does not have a format. Datatypes don't have formats in SQL. — wildplasser
– wildplasser, Commented Oct 30, 2013 at 12:02

Pavel Stehule · Accepted Answer · 2013-10-30 12:11:49Z

1

There is wrong using of apostrophes

Should be

SELECT * FROM public."table1" 
 WHERE "registrationTimestamp" BETWEEN 
            to_timestamp('22-10-2013 00:00', 'DD-MM-YYYY HH24:MI')
        AND to_timestamp('22-10-2013 23:59', 'DD-MM-YYYY HH24:MI')

answered Oct 30, 2013 at 12:11

Pavel Stehule

46.6k6 gold badges103 silver badges102 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL timestamp select

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related