[CAY-2269] Add support for date/time components extraction in expression functions.

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.B1
• Component/s: Core Library
• Labels: expressions
• Assignee: Nikita Timofeev
• Reporter: Nikita Timofeev
• Created: 16/Mar/17 12:04
• Updated: 20/Mar/17 10:20
• Resolved: 20/Mar/17 10:20

Description

Add support for the following date/time component-extracting functions:

1. year()
2. month()
3. week()
4. dayOfYear()
5. day() and/or dayOfMonth()
6. dayOfWeek()
7. hour()
8. minute()
9. second()

However not all DB can support this functions, e.g. sqlite has its own vision for date\time functions, FrontBase don't support this functions completely.