Oracle foundation — single line function (date time function)

Time:2020-9-19

Date time function

The default date format of Oracle system is dd-mon-yy.

The date time function is used to return the current date and time of the system, and to process the date and event type data.

function describe
ADD_MONTHS(date,count) Add count months to the specified date
LAST_DAY(date) Returns the last day of the month of date
MONTHS_BETWEEN(date1,date2) How many months is the interval between date1 and date2
NEXT_DAY(date, ‘day’) Returns the day of the first week after the specified date
SYSDATE Gets the current date value of the system
CURRENT_TIMESTAMP Gets the date value of the current time
ROUND(date, ‘day’) Round the date
TRUNC(date, ‘day’) Intercept the date
Format of Oracle date: yyyy, YY, month, Mon, mm, day, DD, HH, MI, SS

Recommended Today

Solutions to leetcode problems and knowledge points 1. Sum of two numbers

Title Link 1. Two Sum  difficulty: $/ color {00965e} {easy}$ Knowledge points 1. Hash (hash) function The classic hash function times33 is widely used, and the core algorithm is as follows: hash(i) = hash(i-1) * 33 + str[i] Laruence has an article about:Hash algorithm in PHP 2. Hash collision processing method 2.1 chain address method […]