Oracle Date Functions

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

NEW_TIME

Converts a date from time zone1 to a date in time zone2

EXTRACT

Extracts a value from a date or interval value

ROUND

Returns a date rounded to a specific unit of measure

TRUNC

Returns a date truncated to a specific unit of measure

ADD_MONTHS

Returns a date with a specified number of months added

CURRENT_TIMESTAMP

Returns the current date and time in the time zone of the current SQL session as set by the ALTER SESSION command

LOCALTIMESTAMP

Returns the current date and time in the time zone of the current SQL session as set by the ALTER SESSION command

CURRENT_DATE

Returns the current date in the time zone of the current SQL session as set by the ALTER SESSION command

SESSIONTIMEZONE

Returns the current session's time zone as a time zone offset or a time zone region name

SYSTIMESTAMP

Returns the current system date and time (including fractional seconds and time zone) on your local database

SYSDATE

Returns the current system date and time on your local database

NEXT_DAY

Returns the first weekday that is greater than a date

LAST_DAY

Returns the last day of the month based on a date value

MONTHS_BETWEEN

Returns the number of months between date1 and date2

TZ_OFFSET

Returns the time zone offset of a value

DBTIMEZONE

returns the database time zone as a time zone offset or a time zone region name


Set pelajaran terkait

Adolescence Chapter 5: Peer Groups

View Set

Human Nutrition Chapter 10 Review

View Set

CHAPTER 19- BREACH OF CONTRACT AND REMEDIES

View Set

NCLEX Pharm: Psychiatric Medications

View Set

JOMC 101 (Princ Mass Media) Exam 3

View Set

what are the advantages and disadvantages of sexual reproduction and asexal

View Set

Unit 13: Types and Characteristics of Fixed Income (Debt) Securities and Methods Used to Determine Their Value

View Set