<rt id="bn8ez"></rt>
<label id="bn8ez"></label>

  • <span id="bn8ez"></span>

    <label id="bn8ez"><meter id="bn8ez"></meter></label>

    javaGrowing

      BlogJava :: 首頁(yè) :: 新隨筆 :: 聯(lián)系 :: 聚合  :: 管理 ::
      92 隨筆 :: 33 文章 :: 49 評(píng)論 :: 0 Trackbacks

    Oracle/PLSQL: To_Date Function


    In Oracle/PLSQL, the to_date function converts a string to a date.

    The syntax for the to_date function is:

    to_date( string1, [ format_mask ], [ nls_language ] )

    string1 is the string that will be converted to a date.

    format_mask is optional. This is the format that will be used to convert string1 to a date.

    nls_language is optional. This is the nls language used to convert string1 to a date.


    The following is a list of options for the format_mask parameter. These parameters can be used in many combinations.

    Parameter Explanation
    YEAR Year, spelled out
    YYYY 4-digit year
    YYY
    YY
    Y
    Last 3, 2, or 1 digit(s) of year.
    IYY
    IY
    I
    Last 3, 2, or 1 digit(s) of ISO year.
    IYYY 4-digit year based on the ISO standard
    RRRR Accepts a 2-digit year and returns a 4-digit year.
    A value between 0-49 will return a 20xx year.
    A value between 50-99 will return a 19xx year.
    Q Quarter of year (1, 2, 3, 4; JAN-MAR = 1).
    MM Month (01-12; JAN = 01).
    MON Abbreviated name of month.
    MONTH Name of month, padded with blanks to length of 9 characters.
    RM Roman numeral month (I-XII; JAN = I).
    WW Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year.
    W Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh.
    IW Week of year (1-52 or 1-53) based on the ISO standard.
    D Day of week (1-7).
    DAY Name of day.
    DD Day of month (1-31).
    DDD Day of year (1-366).
    DY Abbreviated name of day.
    J Julian day; the number of days since January 1, 4712 BC.
    HH Hour of day (1-12).
    HH12 Hour of day (1-12).
    HH24 Hour of day (0-23).
    MI Minute (0-59).
    SS Second (0-59).
    SSSSS Seconds past midnight (0-86399).
    FF Fractional seconds. Use a value from 1 to 9 after FF to indicate the number of digits in the fractional seconds. For example, 'FF4'.
    AM, A.M., PM, or P.M. Meridian indicator
    AD or A.D AD indicator
    BC or B.C. BC indicator
    TZD Daylight savings information. For example, 'PST'
    TZH Time zone hour.
    TZM Time zone minute.
    TZR Time zone region.

    For example:

    to_date('2003/07/09', 'yyyy/mm/dd') would return a date value of July 9, 2003.
    to_date('070903', 'MMDDYY') would return a date value of July 9, 2003.
    to_date('20020315', 'yyyymmdd') would return a date value of Mar 15, 2002.
    posted on 2006-05-22 18:45 javaGrowing 閱讀(1056) 評(píng)論(1)  編輯  收藏 所屬分類(lèi): oracle

    評(píng)論

    # re: Oracle/PLSQL: To_Date Function 2006-09-25 13:59 aishwarya rai
    good site  回復(fù)  更多評(píng)論
      

    主站蜘蛛池模板: 免费看片免费播放| 国产精品九九久久免费视频| 亚洲AV色吊丝无码| 亚洲第一页在线观看| 亚洲日本中文字幕区| 亚洲第一福利网站| 亚洲一区影音先锋色资源| 久久亚洲熟女cc98cm| 亚洲视频一区二区在线观看| 亚洲精品国产免费| 亚洲激情电影在线| 亚洲高清视频在线| 丰满亚洲大尺度无码无码专线| 亚洲成a∧人片在线观看无码 | 大学生一级毛片免费看| 国产情侣激情在线视频免费看| 国产一卡2卡3卡4卡无卡免费视频 国产一卡二卡3卡四卡免费 | 亚洲AV无码日韩AV无码导航| 久久久国产精品亚洲一区| 亚洲毛片免费观看| 亚洲欧美熟妇综合久久久久| 老湿机一区午夜精品免费福利| 一级视频在线免费观看| 成人无码a级毛片免费| 91香蕉国产线观看免费全集| 一个人免费观看在线视频www| 午夜视频免费观看| 亚洲欧美日韩一区二区三区在线| 亚洲Av永久无码精品一区二区| 黄色a三级三级三级免费看| 国产免费久久精品丫丫| 久久国产精品成人片免费| 毛片免费视频播放| 亚洲国产人成中文幕一级二级| 亚洲精品二区国产综合野狼| 亚洲理论片中文字幕电影| 亚洲久热无码av中文字幕| a级毛片免费网站| jjizz全部免费看片| 国产又大又长又粗又硬的免费视频| 国产亚洲av片在线观看18女人|