| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Oracle SQL Time | Oracle | Beginner /
Kevin O'Neill | 4090 since
5/1/2002 9:37:58 AM | Unrated
|
| |
Instead of displaying the time like this
09:22:12 a.m.
Displays it like this:
9:22 a.m. |
| |
| |
| |
|
Relative Date Name function | SQL Server 2000 | Intermediate /
Nigel Smith | 4385 since
7/9/2004 8:53:23 AM | Unrated
|
| |
Demonstrates the user of a SQL 2000 user function which can return a relative date name, based on 2 date parameters. |
| |
| |
| |
|
Round SQL DateTime to the Nearest Specified Interval | SQL Server 2000 | Beginner /
Tom Bruinsma | 13734 since
9/22/2005 11:16:23 AM |
By 2 Users
|
| |
The purpose of this function is to round time to the nearest specified time interval. The function is extremly easy to use and takes two arguments, the datetime and the interval in minutes. If you like the code, please vote. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
 |
 Round Time | Oracle | Advanced /
Andy Archer | 5447 since
10/5/2007 11:49:27 AM | Unrated
|
| |
Based on the value of the i_minutes input, this PL/SQL stored function returns the i_date_and_time input rounded to the nearest hour, half hour, quarter hour, etc. With SQL*Plus test script. |
| |
| |
| |
|
 Selecting a date range | SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Matthew Roberts | 19585 since
1/3/2001 9:53:34 AM |
By 4 Users
|
| |
Explains how to select a date range without omitting the ending date. |
| |
| |
| |
|
Solution For Date Format Problems in SQL Server | SQL Server 2000, Oracle, Other | Advanced /
Shaikh Mohammed Zaid | 3798 since
8/21/2008 12:19:13 PM |
By 1 Users
|
| |
There are lot Format which is Required by ur Client but SQL is Unable to Deliver it Directly
So here is the indirect way to do it
There are lot of people who ask me same problem, SO i posting this
Take care
Have Fun
IMP: There are Numerous way to do it. ...(description truncated) (ScreenShot) |
| |
| |
| |
|
sp_fixedstring_to_datetime | SQL Server 7.0 | Intermediate /
Paul Harris | 5601 since
4/21/2001 10:08:21 AM | Unrated
|
| |
Converts a fixed-length string variable of format YYYYMMDDHHMMSS to a datetime variable |
| |
| |
| |
|
SQL CALENDAR | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Advanced /
John Overton | 34502 since
9/20/2002 3:01:38 PM |
By 11 Users
7 Excellent Ratings
|
| |
UPDATED:Produces Full Calendar for each Month in a Year. Just pass year as an integer. Let me know if it proves useful. Call it Like:
Execute Calendar 2002 |
| |
| |
| |
|
SQL Calendar (Updated) | SQL Server 2000 | Advanced /
John Overton | 17694 since
3/1/2003 10:06:29 AM |
By 8 Users
8 Excellent Ratings
|
| |
Displays complete calendar of any given year. Updated version of original code... Easy to alter to fit your needs.
Call--- Execute Calendar 2003 |
| |
| |
| |
|
SQL Function For Getting The Last Day of the Month | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Advanced /
Shirish Patel | 3182 since
3/19/2011 3:59:18 PM | Unrated
|
| |
SQL Function For Getting The Last Day of the Month |
| |
(ScreenShot)
