| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 A Simple SQL Code to determine Dates for current and previous months | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Duane Warsham | 3774 since
7/12/2011 2:57:57 PM | Unrated
|
| |
Gets dates for the first, last day of current month, gets last day of last month, first day of next month. |
| |
| |
| |
 |
 Add Current time To your date field | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Eassa Saleh | 16211 since
5/29/2003 3:09:06 AM |
By 4 Users
|
| |
Enter current Time to your date field |
| |
| |
| |
|
 Add Hours Or Days Or Weeks Or Months Or Years | Oracle | Intermediate /
Andy Archer | 11440 since
6/14/2012 5:18:22 PM | Unrated
|
| |
Using simple Oracle date functionality, this PL/SQL stored function adds the specified number of hours, days, weeks, months, or years to the IN date and time, returning the new date and time. With SQL*Plus test script. |
| |
| |
| |
|
allday.sql | SQL Server 7.0, SQL Server 6.5 and earlier, Informix
, Oracle, Other | Beginner /
Dhairyasheel Tawde | 14868 since
5/8/2002 8:25:56 AM |
By 2 Users
|
| |
You enter a day say 'monday' & it finds the dates of all mondays in the month. |
| |
| |
| |
|
Calculate Age | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 35108 since
7/25/2000 8:35:24 PM |
By 2 Users
|
| |
How to calculate AGE in years. (note: The DATEDIFF function in MS SQL Server gives the distance between year boundaries & as such cannot be used to calculate the age.) |
| |
| |
| |
|
Calendar | Oracle | Advanced /
Andy Archer | 38498 since
12/21/2008 11:10:23 AM |
By 2 Users
|
| |
Calendar is a PL/SQL stored procedure that displays a 12-month calendar for the input year upon SQL*Plus execution. (This is a modified version of Sergio Rueda's 7/25/2002 "calproc.sql" Planet Source Code submission). |
| |
| |
| |
|
 CALENDAR (Default @@DATEFIRST = Monday) | SQL Server 2000, SQL Server 7.0 | Advanced /
ragoldss | 9078 since
1/11/2005 6:09:06 AM |
By 4 Users
|
| |
Orjinal SP By: John Overton
Revisied By: Ęsmail Yurtsever (ScreenShot) |
| |
| |
| |
|
calproc.sql | Oracle | Intermediate /
Sergio Rueda | 12981 since
7/25/2002 11:09:18 AM |
By 1 Users
|
| |
Creates a 12 month calendar for any given year |
| |
| |
| |
|
Code to get the last day of the given month! | SQL Server 7.0 | Advanced /
Narayana Vyas Kondreddi | 15117 since
6/20/2001 10:29:35 AM |
By 2 Users
2 Excellent Ratings
|
| |
To get the last day of the given month!
UPDATED VERSION OF THIS CODE CAN BE FOUND AT: http://vyaskn.tripod.com/code.htm |
| |
| |
| |
|
Compare datetime field | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Sachin Pendgaonkar | 25343 since
11/25/2002 3:53:41 AM |
By 4 Users
|
| |
Compare datetime values in sql with the value entered by the user or you compare with todays date |
| |
(ScreenShot)
