Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
Oracle PL/SQL Syntax & Examples [
Return To Index
]
Jump to:
Select a Location
PSOUG Home Page
Oracle Code Library
mySQL Code Library
PHP Code Library
JavaScript Code Library
Oracle Terms & Definitions
Oracle Error Codes
PSOUG Community Blogs
Oracle Jobs Board
PSOUG Forum
Oracle User Group Directory
Free Oracle Magazines
Online Learning Center
PSOUG Presentations
Advanced Code Search
News and Events
Sponsors Page
Submit Code
Contact Us
Looking for the original pages? (formerly called "
Morgan's Library
") You can find them
here
.
Term:
DATE
Definition:
Related Code Snippets:
Date Functions: Return next date
- Takes a date and returns the next date, a simple skeleton for d...
Date Functions: Add Months
- The add_months function returns a date plus n months.
Date Functions: Current_date
- The current_date function returns the current date in the time zone...
Date Functions: Round (date)
- The round function returns a date rounded to a specific unit of measure
Date Functions: To_Date
- The to_date function converts a string to a date.
Date Functions: TRUNC (date)
- The trunc function returns a date truncated to a specific unit of m...
Date Math Sample 1
- An example of subtracting dates to get the difference between them.
UPDATE
- A sample of an update statement.
Date functions: Current Date
Date Functions: Add and Subtract from Dates
- Adding and subtracting from date values.
Date Functions: ADD_MONTHS
- Add a month or months to a given date.
Date functions: CURRENT_DATE
- The CURRENT_DATE function returns the current date in the session t...
Date Functions: DUMP
- DUMP returns a VARCHAR2 value containing the datatype code, length in bytes...
Date Functions: GREATEST
- Returns the latest date value.
Date Functions: LEAST
- Returns the earliest date.
Date Functions: INTERVAL
- Interval to adjust date-time.
Date Functions: LAST_DAY
- Returns the last date (not day) of a given month.
Date Functions: LENGTH
- Returns length in characters.
Date Functions: LENGTHB
- Similar to LENGTH, but returns the length in bytes.
Date Functions: MAX
- Returns the latest date.
Date Functions: MIN
- Returns the earliest date.
Date Functions: MONTHS_BETWEEN
- Returns the months in between (separating) two given dates.
Date Functions: NEW_TIME
- Returns the date and time in time zone zone2 when date and time in time...
Date Functions: NEXT_DAY
- Gives you the date of next specified date following a given date.
Date Functions: ROUND
- Returns date rounded to the unit specified by the format model. If you omi...
Home
:
Code Library
:
Sponsors
:
Privacy
:
Terms of Use
:
Contact Us
30 users online © 2009 psoug.org
PSOUG LOGIN
Username:
Password:
Forgot your password?