/SQL/Sql current year

Sql current year

Current year sql

-- Oracle
SELECT extract(YEAR FROM sysdate) FROM dual;			// number
SELECT to_char(sysdate, 'YYYY') FROM dual;				// varchar

2

Get current year sql

select year(getdate())

1

Sql current year

/*My workbench*/
 YEAR(CURDATE())

0

Similar codes

8 votes235 views4 answers
Convert date to dd/mm/yyyy sql
SQL
11 votes198 views6 answers
Distinct sql
SQL
0 vote142 views1 answer
FindAllBy
SQL
0 vote218 views1 answer
SQL server datetime compare
SQL
0 vote195 views1 answer
Mariadb search columns
SQL
5 votes194 views1 answer
Oracle ora-00054 causes
SQL
0 vote192 views1 answer
How to print mysql query of codeigniter query builder
SQL
1 vote189 views1 answer
How to select random rows from table
SQL
3 votes249 views2 answers
Funktion LOWER/UPPER sql
SQL
2 votes190 views1 answer
Drop table if exists in postgres
SQL

Share