Sql

SELECT EXTRACT(YEAR FROM column_date);

select extract(year from your_column) from your_table;

PREVIOUS	NEXT

Code Example
Sql :: sql replace null with 0
Sql :: get last record in sql
Sql :: oracle trace file
Sql :: Uncaught Error: Call to undefined function DatabaseOldmysqli_connect()
Sql :: sql select only time from datetime
Sql :: sql convert unix time to date
Sql :: having vs where
Sql :: alter table add column
Sql :: sql drop database statement
Sql :: date to string sql
Sql :: how to select all attributes from a row if there is a certain string in it MySQL
Sql :: alter table add column with default value
Sql :: how to get table current identity value in sql server
Sql :: installing postgresql ubuntu
Sql :: ORACLE SHOW AVAILABLE DB LINK
Sql :: mysql select last 10 rows
Sql :: mysql create table like
Sql :: sql server current date minus 5 years
Sql :: tsql cmd exec script from file
Sql :: docker run mysql image
Sql :: node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
Sql :: view t-sql mail configuration
Sql :: select latest entry in sql table
Sql :: sql server obtener fecha en formato dd/mm/yyyy
Sql :: postgres set default schema
Sql :: postgresql search object in array
Sql :: how to fetch first 5 characters in sql
Sql :: oracle drop index if exists
Sql :: sql update null values
Sql :: snap remove mysql workbench