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 :: having count greater than 1 mysql
Sql :: oracle failed login attempts
Sql :: day of the week sqlite
Sql :: error code 1175 mysql fix
Sql :: sqlite3 how to get column names of a table
Sql :: how to check database size mysql
Sql :: sql sum if
Sql :: mysql date - 1 day
Sql :: delete triger pl pg sql
Sql :: sql set auto increment back to 0
Sql :: add new column to the table mysql
Sql :: dirinfo.name my snippets in stored procedure
Sql :: oracle export trigger ddl
Sql :: Sql Server join multiple column values and separate with comma
Sql :: oracle session date format
Sql :: How to select the nth row in a SQL database table?
Sql :: sql select column names
Sql :: mysql extract month
Sql :: oracle apex list connected users
Sql :: sql left join exists
Sql :: helptext in sql
Sql :: start mysql server using docker
Sql :: add postgresql to path
Sql :: postgres list tables and row counts
Sql :: login to database mysql terminal
Sql :: strict in postgres SQL
Sql :: create mysql user on all hosts
Sql :: sql if null then 0
Sql :: postgres list all roles
Sql :: mysql create table like