/SQL/Get current year sql

Get current year sql

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

Similar codes

0 vote154 views1 answer
Least spark sql
SQL
17 votes164 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote143 views1 answer
Mysql events not work
SQL
0 vote137 views1 answer
Search column name sql
SQL
17 votes138 views6 answers
Current date in sql
SQL
0 vote146 views2 answers
Sql regex vowel
SQL
0 vote276 views1 answer
Sqlite display data in separated columns
SQL
12 votes141 views1 answer
How to change the value of a table in sql
SQL
0 vote174 views2 answers
How to install psql in ubuntu
SQL
0 vote140 views1 answer
Write a query to peint the pattern P(20)
SQL

Share