Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • 1.4.0
    • None
    • Table SQL / API
    • None

    Description

      DATE_FORMAT(date,format) Formats the date value according to the format string.

      • Syntax:
        DATE_FORMAT(date,format)
      • Arguments
        **date: -
        **format: -
      • Return Types
        String
      • Example:
        DATE_FORMAT('2009-10-04 22:23:00', '%W %M %Y') -> 'Sunday October 2009'
        DATE_FORMAT('1900-10-04 22:23:00','%D %y %a %d %m %b %j') -> '4th 00 Thu 04 10 Oct 277'

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              sunjincheng121 sunjincheng
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: