Sql

SELECT EXTRACT(YEAR FROM '2018-07-22')
Code language: SQL (Structured Query Language) (sql)

SELECT YEAR(DateTimeField)
FROM MyTable

SELECT FORMAT(<your-date-field>,"YYYY-MM") AS year-date FROM <your-table>

PREVIOUS	NEXT

Code Example
Sql :: oracle list columns in schema
Sql :: sql get last inserted row
Sql :: datediff
Sql :: date format in postgresql
Sql :: postgres get defined index in table
Sql :: sql select into
Sql :: sql server rtrim everything after character
Sql :: sql stored procedure with output parameters
Sql :: sql select last id
Sql :: mysql replace remove html tag
Sql :: mysql set last_insert_id
Sql :: sql pagination oracle
Sql :: mysql store ip address
Sql :: oracle log files
Sql :: default constraint in ms sql
Sql :: select milliseconds mysql
Sql :: sql any
Sql :: update and replace mysql
Sql :: select random sql
Sql :: use float in sql server string
Sql :: full sql mode
Sql :: postgresql contains
Sql :: constraints to columns SQL
Sql :: test the postgresql db connection
Sql :: mysqldump with where clause
Sql :: convert multiple columns to rows in sql server
Sql :: postgress connection refused
Sql :: sql query to select even numbers
Sql :: grant all privileges microsoft sql
Sql :: SQL: get date difference in minutes