Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-2269

Add support for date/time components extraction in expression functions.

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.0.B1
    • Component/s: Core Library
    • Labels:

      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.

        Attachments

          Activity

            People

            • Assignee:
              ntimofeev Nikita Timofeev
              Reporter:
              ntimofeev Nikita Timofeev
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: