Sql

SELECT DATE(column_name) FROM table_name;

SELECT '2018-07-25 10:30:30'::DATE;

# result -> '2018-07-25'

PREVIOUS	NEXT

Code Example
Sql :: create table in mysql mariadb primary key foreign key
Sql :: how to count number of rows in sql
Sql :: insert array postgresql
Sql :: mysql get last 2 month data
Sql :: declare varchar sql server
Sql :: how to get date in sql
Sql :: sql round 2 decimal
Sql :: what is the difference between clustered and non-clustered index in sql server
Sql :: Converting mysql tables to charset utf8mb4
Sql :: sql number columns
Sql :: select top 3 sql
Sql :: how to join tables in sql
Sql :: groupby error in mysql
Sql :: mysql select row with min date
Sql :: mysql root permission denied lost
Sql :: mysql set boolean default value
Sql :: createdb with postgresql on ubuntu
Sql :: run sql script from command line
Sql :: datepart sql server
Sql :: find all tables with column name
Sql :: show oracle parameters
Sql :: QL HAVING Keyword
Sql :: postgresql must appear in the GROUP BY clause or be used in an aggregate function
Sql :: print hello world in sql
Sql :: postgresql function round
Sql :: orderBy sqlalchemy
Sql :: mysql query where in
Sql :: deleting database in sql
Sql :: mysql select or insert current datetime
Sql :: sql query inner join 3 tables