Posted on 2008-07-04 10:32
追风舞者 阅读(232)
评论(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.blogjava.net/pengpenglin/archive/2008/06/30/211589.html