Subscribe
Srinimf
·
Here’s SQL extract function.
SELECT
EXTRACT (DAY FROM CURRENT_DATE);
The result will be a number.
Valid elements are SECOND, MINUTE, HOUR,DAY, MONTH and YEAR.
Related Posts
Srini
Data Engineer with deep AI and Generative AI expertise, crafting high-performance data pipelines in PySpark, Databricks, and SQL. Skilled in Python, AWS, and Linux—building scalable, cloud-native solutions for smart applications.