You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "chenyunren (JIRA)" <ji...@apache.org> on 2018/07/06 02:26:00 UTC
[jira] [Issue Comment Deleted] (TRAFODION-3127) to_char enhancement
[ https://issues.apache.org/jira/browse/TRAFODION-3127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
chenyunren updated TRAFODION-3127:
----------------------------------
Comment: was deleted
(was: |MON|month(3 chars in English)|TO_CHAR (TIMESTAMP '2016-03-01 12:05:10','MON')
result:MAR|
|MM|month(01-12)|TO_CHAR(DATE '2006-12-01','MM')
result:12|
|DY|name of day(3 chars in English) |TO_CHAR (TIMESTAMP '2016-03-01 12:05:10','DY')
result:TUE|
|DAY|Name of day, padded with blanks to length of 9 characters. SUNDAY|result:TUESDAY|
|CC|century|TO_CHAR (TIMESTAMP '2016-03-01 12:05:10','CC')
result:21|
|D|day of week(Sunday (1) to Saturday (7))|TO_CHAR (TIMESTAMP '2016-03-01 12:05:10','D')
result:3|
|DD|day of month(01-31)|TO_CHAR(DATE '2006-12-01','DD')
result:01|
|DDD|day of year(1-366)|TO_CHAR(DATE '2006-12-01','DDD')
result:335|
|W|week of month(1-5)|TO_CHAR(DATE '2006-12-31','W')
result:5|
|WW|week number of year(1-53).The first week starts on the first day of the month.|TO_CHAR(DATE '2006-01-02','WW')
result:01|
|J|Julian day (number of days since January 1, 4713 BC)|TO_CHAR(TIMESTAMP '2001-01-07 00:00:00','J')
result:2451917|
|Q|The quarter of the year (1 - 4)|TO_CHAR(DATE '2006-12-01','Q')
result:4|)
> to_char enhancement
> -------------------
>
> Key: TRAFODION-3127
> URL: https://issues.apache.org/jira/browse/TRAFODION-3127
> Project: Apache Trafodion
> Issue Type: Improvement
> Reporter: chenyunren
> Assignee: chenyunren
> Priority: Major
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)