On Fri, Apr 10, 2015 at 2:24 PM, Maarten Sander <maarten.sander@gingerpayments.com> wrote:
Hi everyone,I’m probably missing something, but it seems that I cannot select entries that are newer than a given timestamp.Below are my attempts and the schema of the table. Any help would be greatly appreciated!Regards,Maartensql>SELECT completed FROM "reporting"."transactions" WHERE completed >= '2015-04-10 00:00:00.0000' ORDER BY completed DESC;+-----------+| completed |+===========++-----------+0 tuples (0.595ms)sql>SELECT completed FROM "reporting"."transactions" WHERE completed >= CAST('2015-04-10 00:00:00.0000' AS TIMESTAMP) ORDER BY completed DESC;+-----------+| completed |+===========++-----------+0 tuples (0.328ms)sql>SELECT completed FROM "reporting"."transactions" ORDER BY completed DESC LIMIT 10;+----------------------------+| completed |+============================+| 2015-04-10 11:50:22.051000 || 2015-04-10 10:55:50.039000 || 2015-04-09 09:41:13.023000 || 2015-04-09 09:39:09.079000 || 2015-04-09 09:35:56.085000 || 2015-04-08 12:55:13.007000 || 2015-04-08 12:37:07.002000 || 2015-04-08 12:28:22.000000 || 2015-04-08 12:25:25.052000 || 2015-04-07 21:59:59.099000 |+----------------------------+10 tuples (0.683ms)sql>\d "reporting"."transactions"CREATE TABLE "reporting"."transactions" ("id" CHAR(36) NOT NULL,"status" VARCHAR(25) NOT NULL,"created" TIMESTAMP NOT NULL,"completed" TIMESTAMP,"currency" CHAR(3) NOT NULL,"amount" BIGINT NOT NULL,"balance" VARCHAR(25) NOT NULL,"payment_method" VARCHAR(50) NOT NULL,"fee_currency" CHAR(3),"fee_amount" BIGINT,"order_id" CHAR(36) NOT NULL,"order_status" VARCHAR(25) NOT NULL,"project_id" CHAR(36) NOT NULL,"merchant_id" CHAR(36) NOT NULL,CONSTRAINT "transactions_id_pkey" PRIMARY KEY ("id"));