| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Compute Age | Oracle | Advanced /
Andy Archer | 12784 since
11/5/2009 9:08:28 AM |
By 6 Users
5 Excellent Ratings
|
| |
This PL/SQL stored procedure returns a person's age in whole years. It returns the number of whole years between two dates, and will also validate a date. Includes three stored function variants and SQL*Plus test scripts. |
| |
| |
| |
 |
 Convert TIMESTAMP values to numeric | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 10502 since
7/27/2000 9:14:31 PM |
By 1 Users
|
| |
How to convert TIMESTAMP values to numeric. |
| |
| |
| |
|
Create Calendar in T-SQL | SQL Server 2000, SQL Server 7.0 | Advanced /
Jeff Moden | 11750 since
8/15/2007 11:22:32 AM |
By 8 Users
7 Excellent Ratings
|
| |
Creates a simple calendar output (single result set) similar to the screen shot. Can be 1 month or up to 179 years of months. (Sorry, previous screen shot didn't "take".) (ScreenShot) |
| |
| |
| |
|
 Date Functions (UDF) - 25 total | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Jason Johnson | 8986 since
4/6/2006 6:03:14 PM |
By 2 Users
|
| |
Use these 25 different Date UDFs to calculate a number of different dates. While there are a few date calculations available on the net, this library is the most extension from what I could find. |
| |
| |
| |
|
Date Ranges | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Rudolf Mouthaan | 7288 since
8/2/2002 4:19:35 PM |
By 1 Users
|
| |
To enter records with sequential dates in a table.
I extract the amount of days with the DateDiff function Which includes month jumps. My code to add sequential dates to a table also calculates month jumps. |
| |
| |
| |
|
DateToIso | SQL Server 2000, SQL Server 7.0 | Beginner /
Tom A. Holder | 5661 since
11/7/2002 7:50:12 AM |
By 1 Users
|
| |
A very simple function I wrote for a multi-lingual web site to output all dates in ISO format YYYY-MM-DD. This function can be used inline.
E.g.
SELECT Name, dbo.DateToIso(SignUpDate) as SignUpDate
FROM Users |
| |
| |
| |
|
Determine Relative Date Description SQL User Defined Function | SQL Server 2000 | Beginner /
Nigel Smith | 6583 since
4/18/2005 6:52:10 AM | Unrated
|
| |
Simple determination of relative description for the month. This could be used when reporting on a regular basis and group the prevoius months of the same calender year as 'YTD' (Year to Date), then the previous month as 'LastMonth' and the current month ...(description truncated) |
| |
| |
| |
|
Difference in 'Days' since last event.txt | SQL Server 2000 | Advanced /
Dinesh Mishra | 3883 since
8/3/2010 9:25:43 AM | Unrated
|
| |
This piece of code checks the difference in 'number of days' since the last event occured. |
| |
| |
| |
|
Digital clock | Other | Beginner /
Mr.Ganesh.S.Shanbhag | 5125 since
5/29/2002 3:02:48 AM |
By 1 Users
|
| |
displays date time & year |
| |
| |
| |
|
Fill Times using specific interval | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Sajid Ali Anjum | 7791 since
6/13/2006 7:22:47 AM |
By 2 Users
2 Excellent Ratings
|
| |
This piece of code can be used in any application to fill the 24 hours time combo box using specified interval.
It formats the time as hour:minute. And displays the times calculated based upon used interval. |
| |
(ScreenShot)
