Sql

#cast it to a DATE format

WHERE observation_date > CAST('2017-12-31' AS DATE)

PREVIOUS	NEXT

Code Example
Sql :: sqlite get date only
Sql :: insert select
Sql :: sql union operator
Sql :: insert into sql
Sql :: mysql show category once count how many products
Sql :: Select with remove white spaces in sql
Sql :: json_remove mysql
Sql :: oracle sql unique
Sql :: 2nd highest value in sql
Sql :: psql check tables command
Sql :: sqlite unix timestamp
Sql :: 1422: Explicit or implicit commit is not allowed in stored function or trigger
Sql :: what is non relational database
Sql :: mysql 5.6 hierarchical recursive query
Sql :: mysql mediumtext
Sql :: t-sql add column
Sql :: unique element in sql
Sql :: when matched in sql server
Sql :: sql 2 way of select unique
Sql :: select only distinct values from another table and excluding from current table
Sql :: sql table creation
Sql :: mysql query where in select
Sql :: array aggre distinct postgres
Sql :: time in sql server
Sql :: show database not empty tables postgres
Sql :: Postgres format number to 2 decimal places
Sql :: replace sql
Sql :: mysql average from two table
Sql :: How to create a comulative Sum column in mysql
Sql :: oracle convert hours to minutes