Home >> SQL >> EXTRACT() aggregate function in SQL

EXTRACT() aggregate function in SQL

EXTRACT() find a value extracted from a date or an internal value.

Example

EXTRACT(YEAR FROM('2017-04-20'))

Output

2017

Post Your Comment

Next Questions
MOD() aggregate function
TRUNC() aggregate function
FLOOR() aggregate function
CEIL() aggregate function
FIRST() aggregate function
LAST() aggregate function
MID() aggregate function
LEN() aggregate function
NOW() aggregate function
FORMAT() aggregate function
COUNT() aggregate function
LOWER() aggregate function
UPPER() aggregate function
INITCAP() aggregate function
SUBSTR() aggregate function
ASCII() aggregate function
LENGTH() aggregate function
TRIM() aggregate function
LTRIM() aggregate function
RTRIM() aggregate function
Create database
Drop database
Select database
Create table
Drop table

Copyright ©2022 coderraj.com. All Rights Reserved.