Search
 
SCRIPT & CODE EXAMPLE
 

SQL

print year of a date sql

SELECT EXTRACT(YEAR FROM CURRENT_DATE)
Comment

PREVIOUS NEXT
Code Example
Sql :: how to drop all tables in postgresql 
Sql :: cheatsheet for sql 
Sql :: pl/sql cursor 
Sql :: set id count mysql 
Sql :: sql date diff 
Sql :: drop index in sql 
Sql :: drop row pgadmin 
Sql :: sql manhattan distance 
Sql :: create new schema mysql 
Sql :: add current timestamp in mysql 
Sql :: ms sql create user 
Sql :: begin transaction sql 
Sql :: postgresql update auto_increment value 
Sql :: create table employees oracle 
Sql :: sql get month from date 
Sql :: sql select where more than one record exists 
Sql :: how to drop all tables in sql 
Sql :: how to transfer pandas datafra,e to sqlite 
Sql :: unsigned int in mysql 
Sql :: sql count number of rows after group by 
Sql :: sql find duplicate records in two tables 
Sql :: restore database postgresql 
Sql :: sql insert from excel 
Sql :: DATEDIFF minute postgres 
Sql :: mssql check if date is greater than today 
Sql :: mysql json query 
Sql :: postgresql import a database of gzip 
Sql :: sql server date format yyyy-MM-ddThh:mm:ss 
Sql :: mysql delete entire row on condition 
Sql :: enter mysql command line 
ADD CONTENT
Topic
Content
Source link
Name
7+3 =