The extract function is synonymous to DATE_PART function. The EXTRACT function returns a date part, such as a day, month, or year, from a time stamp value or expression.
Likewise, there are so many applications that use extract function whenever you require. For example, extract time part of the current datetime and append it to file name to create unique file name. You may have requirement to extract part of timestamp values and pass it to an calling application. The extract function is very useful when you are working with different heterogeneous data sources. Benefits of Extract Function in Amazon Redshift.Amazon Redshift Extract Function Examples.Redshift Extract Function Datepart or Timepart and Abbreviations.
