Sql

SELECT date_part('day', TIMESTAMP '2001-02-16 20:38:40');
Result: 16

SELECT date_part('hour', INTERVAL '4 hours 3 minutes');
Result: 4

PREVIOUS	NEXT

Code Example
Sql :: how to know the username of postgresql
Sql :: mysql remove duplicates
Sql :: mysql get all tables row count
Sql :: sql where contains
Sql :: sql group by year
Sql :: ubuntu reset mysql root password
Sql :: postgres group by 10 minute intervals
Sql :: oracle all tables
Sql :: postgres change column type to uuid
Sql :: how to add CHECK constraint to a column in postgres
Sql :: date format in sql
Sql :: mysql add root password
Sql :: sql offset
Sql :: convert date to dd/mm/yyyy sql
Sql :: change column name in sql
Sql :: mysql set id auto increment
Sql :: oracle sql listagg
Sql :: connectionstring mysql c#
Sql :: create user sql server
Sql :: trouver doublons sql
Sql :: sql common columns
Sql :: mariadb add foreign key
Sql :: postgresql add leading zeros
Sql :: create table in sql
Sql :: run postgres docker
Sql :: mysql export and import
Sql :: mysql datetime to date
Sql :: sql views
Sql :: write sql query to find the second highest salary of employee
Sql :: how to check table lock