The DAY, MONTH, YEAR functions can be used to extract the day, month, and year from a date. These features are most commonly used in
It's all about SQL Server, MySQL, Oracle SQL*Plus, PostgreSQL, NoSQL, Hbase, Apache Pig, Apache Hive, Apache Sqoop, HDFS, MapReduce, ProxySQL, EC2, AWS and MongoDB
Big Data and SQL 