欧美性猛交XXXX免费看蜜桃,成人网18免费韩国,亚洲国产成人精品区综合,欧美日韩一区二区三区高清不卡,亚洲综合一区二区精品久久

EXTRACT extracts and returns the value of a specified datetime field from a datetime or interval value expression.
The field you are extracting must be a field of the datetime_value_expr or interval_value_expr. For example, you can extract only YEAR, MONTH, and DAY from a DATE value. Likewise, you can extract TIMEZONE_HOUR and TIMEZONE_MINUTE only from the TIMESTAMP WITH TIME ZONE datatype.
eg.

• SELECT EXTRACT(YEAR FROM SYSDATE) FROM DUAL; return Current Year
• SELECT EXTRACT(MONTH FROM SYSDATE) FROM DUAL; return Current Month
• SELECT EXTRACT(DAY FROM SYSDATE) FROM DUAL; return Current Day
• SELECT EXTRACT(HOUR FROM SYSDATE) FROM DUAL;Error

       Correct:SELECT EXTRACT(HOUR FROM TIMESTAMP '2005-10-10 10:10:10') FROM DUAL;


• SELECT EXTRACT(MINUTE FROM SYSDATE) FROM DUAL;Error

       Correct:SELECT EXTRACT(MINUTE FROM TIMESTAMP '2005-10-10 10:10:10') FROM DUAL;

       以上是EXTRACT()函數的使用說(shuō)明,英文部分有個(gè)很重要的部分.就是extract 抽取年月日部分和時(shí)分部分的使用方法是不同的.
EXTRACT(YEAR FROM SYSDATE)中FROM 的下一個(gè)參數是日期類(lèi)型的時(shí)候可以抽取年月日.就是說(shuō)這個(gè)參數是日期類(lèi)型的時(shí)候就可以抽取年\月\日,而抽取不了時(shí)\分部分.抽取時(shí)分部分得在FROM 后面加帶TIMESTAMP 且后面加時(shí)間字符.
   這里要注意,在(MINUTE FROM TIMESTAMP '2005-10-10 10:10:10')中,如果把'2005-10-10 10:10:10'用日期類(lèi)型的字段來(lái)代替并轉換成字符類(lèi)型后,也是錯誤的,估計是這方法的問(wèn)題.
    比如(MINUTE FROM TIMESTAMP to_date(to_char(日期類(lèi)型,'YYYY-MM-DD hh24:mi:ss'),'YYYY-MM-DD hh24:mi:ss')),這樣執行不了的.


    如果真要從日期類(lèi)型的字段中抽取時(shí)\分部分用to_char() 函數就可以了.比如to_char(日期類(lèi)型,'hh24:mi')