PostgreSQL timestamp select <p>I'm using Posture and I got error message "invalid input syntax for type timestamp with time zone" when using the following select code:</p> <pre><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')** </code></pre> <p>While <code>registrationTimestamp</code> timestamp format is like following:</p> <pre><code>6/26/2012 6:43:10 PM </code></pre>