Posted on 2008-07-04 10:32
追風(fēng)舞者 閱讀(248)
評(píng)論(0) 編輯 收藏 所屬分類:
Database
Oracle的日期函數(shù):
Oracle從8i開始就提供了大量的日期函數(shù)，這些日期函數(shù)包括對(duì)日期進(jìn)行加減、轉(zhuǎn)換、截取等功能。下面是Oracle提供的日期函數(shù)一覽表
|
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
|
更多詳細(xì)內(nèi)容請(qǐng)參考：
http://www.aygfsteel.com/pengpenglin/archive/2008/06/30/211589.html