SQL execution failed: operator does not exist: bigint >= timestamp without time zone

Question

CREATE TABLE employee (
        id INT PRIMARY KEY,
        username TEXT NOT NULL,
        email TEXT NULL,
        created_on TIMESTAMP NOT NULL,
    
    );
    
    SELECT username, email FROM employee where created_on between '2012-01-20' and '2012-04-24'

Answer 1

That actually seems to work: http://sqlfiddle.com/#!17/ef8e85/1

Mind though that you have a syntax error in your CREATE TABLE, you need to remove the last comma.