Sql

select year(getdate())

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

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

PREVIOUS	NEXT

Code Example
Sql :: can you update NULL in sql
Sql :: insert data from another table
Sql :: postgres change column type to uuid
Sql :: mysql backup query
Sql :: disable trigger sql oracle
Sql :: what is the default password for sql server sa
Sql :: begin transaction in sql
Sql :: check if record exists mysql
Sql :: db.Database.SqlQuery
Sql :: sql where first letter
Sql :: update field sql
Sql :: oracle difference between two dates in seconds
Sql :: mysql CAST(amount as float)
Sql :: drop table with constraints
Sql :: brew install mysql 8
Sql :: mysql else if
Sql :: sql count distinct group by
Sql :: postgresql get difference between two dates
Sql :: sql common columns
Sql :: how to truncate table with foreign key constraint postgresql
Sql :: postgresql insert column
Sql :: rename column sql
Sql :: row number mssql
Sql :: Mysql Create table with foreign keys.
Sql :: sql server backup table
Sql :: oracle list dates without weekends
Sql :: import all databases mysql
Sql :: oracle revoke
Sql :: update and replace mysql
Sql :: check if value is equal to something sql