| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Find Date | Oracle | Advanced /
Andy Archer | 10860 since
2/13/2010 8:58:35 AM |
By 4 Users
4 Excellent Ratings
|
| |
Relative to the i_date_and_time input, this PL/SQL stored function returns a wide variety of dates via just a handful of IN parameters. With SQL*Plus test script. |
| |
| |
| |
|
Find Date For Nth Day | Oracle | Advanced /
Andy Archer | 8855 since
12/18/2007 1:50:47 PM |
By 1 Users
|
| |
This PL/SQL stored function returns the date for the in_nth occurrence of in_dy (Sunday, Monday, etc.) falling before or after in_date_and_time. With SQL*Plus test script. |
| |
| |
| |
|
find dates in Oracle | Oracle | Intermediate /
Andy Archer | 7525 since
12/21/2008 11:10:00 AM |
By 4 Users
4 Excellent Ratings
|
| |
These example Selects from the DUAL table show how to use built-in PL/SQL date functions to find various dates, from "first day of last month" to "first Tuesday after first Wednesday of next quarter". (Beginner to Intermediate). |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
find first and last dates of week | Oracle | Beginner /
Andy Archer | 3889 since
9/4/2008 4:19:36 PM | Unrated
|
| |
Oracle built-in date functionality makes it easy to find, for a given date, the dates for the first and last days of the week. This is a short write-up with examples. |
| |
| |
| |
|
Find Last Not-Month-End IN_DAY | Oracle | Intermediate /
Andy Archer | 1151 since
1/12/2012 3:28:58 PM | Unrated
|
| |
This little PL/SQL stored function returns the date for the last IN_DAY in IN_DATE's month that is not the last day of the month. With a calling function and SQL*Plus test scripts. |
| |
| |
| |
|
Find Months For Day | Oracle | Advanced /
Andy Archer | 3357 since
7/18/2006 4:48:03 PM |
By 2 Users
|
| |
This PL/SQL stored procedure returns the count and names of those months in the input year that have a day of input day name and number. (Is there a practical application beyond finding Friday the 13th? Who knows). |
| |
| |
| |
|
Find Next Date For Day | Oracle | Intermediate /
Andy Archer | 9683 since
10/27/2010 8:06:00 PM |
By 1 Users
|
| |
Relative to the i_date_and_time input, this PL/SQL stored function returns the next date with a day of input day name and number. (Is there a practical application beyond finding Friday the 13th? Who knows). With SQL*Plus test script. |
| |
| |
| |
 |
 Find the last business date | SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Paul Sturgill | 6593 since
5/3/2001 12:55:48 PM |
By 4 Users
|
| |
The purpose of this code is to find the last business day. I come from a financial company and this is used alot to default dates to the last business day. It uses recursion if a holiday is found. <BR>VOTE if you find this useful.<BR>
Thanks |
| |
| |
| |
|
 First and Last Date of Week (Shorter Code) | SQL Server 2000 | Advanced /
Hong Thang | 7633 since
5/20/2010 8:50:57 AM |
By 2 Users
2 Excellent Ratings
|
| |
Get First and Last Date of Week |
| |
| |
| |
|
First day of month | Other | Beginner /
Lewis E. Moten III | 8431 since
3/14/2002 3:43:33 PM |
By 2 Users
|
| |
Pass a date to the function and it will return the first day of the month. Example -
print dbo.firstday('9/2/2002 3:57:31 PM')
will print
'Sep 1 2002 12:00 AM'
|
| |
