| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 How to get only the month end records | SQL Server 2000 | Intermediate /
Sal Chawdhury | 3959 since
4/29/2004 10:45:22 AM |
By 1 Users
|
| |
This code was written to get only the last day's reocrds from a recordset. |
| |
| |
| |
 |
 Is it a leap year? | Oracle | Intermediate /
Andy Archer | 16495 since
9/10/2009 9:20:58 AM |
By 4 Users
2 Excellent Ratings
|
| |
Here are six ways to find out if a year is a leap year: TO_DATE the year concatenated with February 29 in a Select from the DUAL table, or execute one of the five PL/SQL blocks (one in a stored function) that incorporates a leap year algorithm. |
| |
| |
| |
|
java program to marksheet generation | Other | Beginner /
maqsud rasul sayed | 8486 since
10/8/2010 8:33:17 AM | Unrated
|
| |
hi friends this a simple mini project for diploma holder marksheet generation |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
Last Day of month | Other | Beginner /
Lewis E. Moten III | 5564 since
3/14/2002 3:48:45 PM |
By 4 Users
|
| |
Returns last day, hour, minute, second of date passed to it. Example - print dbo.lastday('9/2/2002 3:57:31 PM') would return 'Sep 30 2002 11:59PM'. This function depends on dbo.FirstDay() located on PSC under First day of month |
| |
| |
| |
|
Month Range Table | Other | Beginner /
Lewis E. Moten III | 8536 since
3/14/2002 3:55:00 PM |
By 1 Users
|
| |
Build a table and populate it with dates between a specified range. I often use this method to create a set of months available, then use a left outer join to add any existing data within an actual table. |
| |
| |
| |
|
Month/Year function | Other | Beginner /
Lewis E. Moten III | 5682 since
3/14/2002 3:32:02 PM |
By 2 Users
|
| |
Returns a date formated as "Mmm YYYY" (Ex. Oct 2002). Not anything ground breaking ... |
| |
| |
| |
|
 Next Friday, 13-th | Oracle | Beginner /
Bakhyt Matkarimov | 5036 since
4/9/2003 6:28:11 AM | Unrated
|
| |
Date manipulations in Oracle SeQUEL |
| |
| |
| |
|
No Of Seconds Elapsed Since Midnight | SQL Server 2000 | Advanced /
Dinesh Mishra | 4813 since
8/3/2010 9:25:57 AM | Unrated
|
| |
This piece of code checks the number of seconds elapsed since midnight.We are assuming that today is 31st july 2010 and number of seconds are counted from 00:00:00 of 31st July 2010 midnight. |
| |
| |
| |
|
nth Occurrence of any Day from any Date | SQL Server 2000 | Intermediate /
John Cappelletti | 4200 since
6/7/2003 5:32:19 PM | Unrated
|
| |
This little UDF will allow you to find the nth occurrence of any day from any date (positive or negative).
|
| |
| |
| |
|
one-month calendar | Oracle | Advanced /
Andy Archer | 506 since
4/5/2013 5:04:50 PM | Unrated
|
| |
This SQL*Plus script executes a PL/SQL block to display a one-month calendar for the input month and year (solicited at the prompt). Default is the current month, for which today's date is highlighted. (ScreenShot) |
| |
(ScreenShot)
