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 :: check database status oracle
Sql :: sql auto timestamp
Sql :: sql string starts with
Sql :: mysql convert column to uppercase
Sql :: oracle schema size
Sql :: hangfire clear all jobs
Sql :: mysql insert from local csv
Sql :: how to reset table in sql server
Sql :: mysql select column where has non int values
Sql :: mysql user change password
Sql :: migrate sql table another database
Sql :: date_trunc postgres
Sql :: get last three characters in mysql column
Sql :: change default role snowflake
Sql :: sql insert inserted id
Sql :: how to remove a column from a table in MySQL
Sql :: racle create auto increment column
Sql :: mysql concatenate select results
Sql :: mysql current date
Sql :: copy data from one table column to another table column in sql
Sql :: mysql update row
Sql :: mysql inner join 3 tables
Sql :: sql server sleep
Sql :: oracle trigger after connect
Sql :: show all database inside postgresql
Sql :: csv to sqlite python
Sql :: how to get the date diff on once field in sql server
Sql :: how to assign date field for table in mysql
Sql :: get date from timestamp oracle
Sql :: How to convert DateTime to VarChar SQL