between ... and ...

[timwis]

ie. $where=date between '2015-01-10T12:00:00' and '2015-01-10T14:00:00'

https://dev.socrata.com/docs/functions/between.html

How is this written in postgres?

[timwis]

Also not between, though that's not supported by node-soda2-parser

[andrewbt]

I believe Postgres dates are greater than and less than each other, like numerical values. So I've written the above as

select * from datetable where datecol <= '2015-01-10T12:00:00' and datecol >= '2015-01-10T14:00:00'

I think.

[timwis]

It probably supports both. Looks like between and is supported too:

https://www.postgresql.org/docs/9.1/static/functions-comparison.html