Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
Oracle PL/SQL Category
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
To view the original pages (which were formerly called "
Morgan's Library
"), you can click
here
.
<<
<
1
2
3
4
5
6
7
8
9
10
>
>>
Date Functions: DUMP
- DUMP returns a VARCHAR2 value containing the datatype code, lengt...
Date Functions: EXTRACT
- Extracts and returns the value of a specified datetime field f...
Date Functions: GREATEST
- Returns the latest date value.
Date Functions: INTERVAL
- Interval to adjust date-time.
Date Functions: LAST_DAY
- Returns the last date (not day) of a given month.
Date Functions: LEAST
- Returns the earliest date.
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 ti...
Date Functions: NEXT_DAY
- Gives you the date of next specified date following a given date.
Date Functions: NUMTODSINTERVAL
- Converts a number to an INTERVAL DAY TO SECOND literal.
Date Functions: NUMTOYMINTERVAL
- Converts n to an INTERVAL YEAR TO MONTH literal.
Date Functions: Return next date
- Takes a date and returns the next date, a simple skel...
Date Functions: ROUND
- Returns date rounded to the unit specified by the format model. ...
Date Functions: Round (date)
- The round function returns a date rounded to a specific u...
Date Functions: SYSDATE
- Returns the current date and time set for the operating system...
Date Functions: TO_CHAR
- Converts DATE and TIMESTAMP to VARCHAR2 with the specified ...
Date Functions: To_Date
- The to_date function converts a string to a date.
Date Functions: TO_DSINTERVAL
- Converts a string to an INTERVAL DAY TO SECOND DataType.
Date Functions: TO_NCHAR
- Converts a DATE or TIMESTAMP from the database character set...
Date Functions: TO_YMINTERVAL
- Converts a string to an Interval Year to Month data type.
Date Functions: TRUNC
- Convert a date to the date it would be at midnight. Using the...
Date Functions: TRUNC (date)
- The trunc function returns a date truncated to a specific...
Date Functions: WHERE Clause Joins
- Examples of using dates in WHERE Clause Joins.
Date Math Sample 1
- An example of subtracting dates to get the difference between them.
Date/Time Calculations: Get seconds between dates
- Calculates the number of seconds bet...
Date: Find first day of the month
- Returns the first day of a given month.
<<
<
1
2
3
4
5
6
7
8
9
10
>
>>
Home
:
Code Library
:
Sponsors
:
Privacy
:
Terms of Use
:
Contact Us
33 users online © 2009 psoug.org
PSOUG LOGIN
Username:
Password:
Forgot your password?