trafodion-codereview mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DaveBirdsall <...@git.apache.org>
Subject [GitHub] trafodion pull request #1656: [TRAFODION-3159] Add *Syntax Descriptions and ...
Date Tue, 24 Jul 2018 18:24:35 GMT
Github user DaveBirdsall commented on a diff in the pull request:

    https://github.com/apache/trafodion/pull/1656#discussion_r204862675
  
    --- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_functions_and_expressions.adoc
---
    @@ -9066,13 +9066,220 @@ second argument describes the format of the character value.
     TO_CHAR(character-expression [,format-string])
     ```
     
    +[[to_char_syntax]]
    +=== Syntax Description of TO_CHAR
    +
     * `_character-expression_`
     +
     is an expression that gives a datetime value.
     
     * `_format-string_`
     +
    -is one of the following character string literals:
    +.Details of `_format-string_`
    +[cols="3*.^"]
    +|===
    +^| *Supported* `_character-expression_` 
    +^| *`_format-string_`* 
    +^| *Description* 
    +
    +a| * `_datetime-expression_` 
    +** DATE 
    +** TIMESTAMP 
    +| 'CC'
    +| Two-digital century.
    +
    +a| * `_datetime-expression_` 
    +** DATE 
    +** TIMESTAMP 
    +| 'D'
    +| Day of week (1-7), where 1 is Sunday, 6 is Saturday. +
    +This is not configurable.
    +
    +a| * `_datetime-expression_` 
    +** DATE 
    +** TIMESTAMP 
    +| 'DD'
    +| Day of month (01-31).
    +
    +a| * `_datetime-expression_` 
    +** DATE 
    +** TIMESTAMP 
    +| 'DDD'
    +| Day of year (001-366).
    +
    +a| * `_datetime-expression_` 
    +** DATE 
    +** TIMESTAMP 
    +| 'DY'
    +a| Name of day, which is a three-letter abbreviation for the day in uppercase. +
    +
    +Following values are valid: +
    --- End diff --
    
    Suggest "The following... "


---

Mime
View raw message