Posted on 2008-07-04 10:32
追風舞者 閱讀(248)
評論(0) 編輯 收藏 所屬分類:
Database
Oracle的日期函數:
Oracle從8i開始就提供了大量的日期函數，這些日期函數包括對日期進行加減、轉換、截取等功能。下面是Oracle提供的日期函數一覽表
|
Function
|
Use
|
|
ADD_MONTHS
|
Adds months to a date
|
|
LAST_DAY
|
Computes the last day of the month
|
|
MONTHS_BETWEEN
|
Determines the number of months between two dates
|
|
NEW_TIME
|
Translates a time to a new time zone
|
|
NEXT_DAY
|
Returns the date of the next specified weekday
|
|
ROUND
|
Rounds a date/time value to a specified element
|
|
SYSDATE
|
Returns the current date and time
|
|
TO_CHAR
|
Converts dates to strings
|
|
TO_DATE
|
Converts strings and numbers to dates
|
|
TRUNC
|
Truncates a date/time value to a specific element
|
更多詳細內容請參考：
http://www.aygfsteel.com/pengpenglin/archive/2008/06/30/211589.html