#4 Date/Timestamp related single row function in oracle
#SQL (Oracle)
single row Date function
CURRENT_TIME
CURRENT_TIMESTAMP
SYSDATE
SYSTIMESTAMP
DBTIMEZONE
SESSIONTIMEZONE
How to change the date format in DB?
How to change the timestamp in DB?
EXTRACT(TIME,DATE)
ADD_MONTHS
MONTHS_BETWEEN
NEXT_DAY
LAST_DAY
How to extract the month from date ?
How to extract the day from date ?
How to know the day like monday,tuesday from date ?
How to change the date format in DB?
How to know month name from date ?