| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 Fiscal Year Wise Time Dimension | SQL Server 2000, SQL Server 7.0 | Advanced /
Shivanand Iyer | 5801 since
4/17/2006 4:32:57 PM | Unrated
|
| |
Populates Time Dimension on basis of Standard Calendar and Fiscal Calendar |
| |
| |
| |
|
fn_GetAge | SQL Server 2000 | Intermediate /
Markus Q | 6635 since
10/20/2003 12:01:44 PM | Unrated
|
| |
This function will calculate a persons age based on inputs. SQL server doesn't allow the use of non-deterministic functions in User Defined Functions, so, this fn requires two inputs, the DOB and the GETDATE() |
| |
| |
| |
|
function for returning the date part of the date | SQL Server 2000, SQL Server 7.0 | Intermediate /
harshal mistry | 5428 since
6/4/2003 12:44:07 PM |
By 2 Users
|
| |
This function returns the date part of the datetime value . |
| |
| |
| |
|
 Function For Time Format | Oracle | Intermediate /
jtanwar | 7650 since
2/27/2002 9:43:27 PM | Unrated
|
| |
Some of the Reports Needs the Time to be reprsented as MM:SS Format
But in the Database table it may be stored in Seconds, so to Convert
It Following Function can be used.
And to use this Function with sql queries is just like any other SQL
Function.
S ...(description truncated) |
| |
| |
| |
|
Get exact Year, Month and Day between Dates | SQL Server 2000, SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Israel Balderrama | 5733 since
10/9/2007 2:12:26 PM | Unrated
|
| |
This code get exact Year, Month and Day between Dates, using date functions (datediff, datepart).
Example, if you have two dates ('08/01/2006' and '09/09/2007') if you wants to know how years, months and days exists between both dates, the code returns:
Y ...(description truncated) |
| |
| |
| |
|
Get First Day of Month (SQL/Oracle versions) | SQL Server 7.0, SQL Server 6.5 and earlier, Oracle | Beginner /
James Travis | 31781 since
11/6/2001 6:37:07 AM |
By 4 Users
|
| |
Get the first day of the month more efficiently. |
| |
| |
| |
|
Get monday date | SQL Server 7.0, SQL Server 6.5 and earlier | Beginner /
Umachandar | 8872 since
7/25/2000 8:33:49 PM |
By 2 Users
|
| |
Get monday date given any date. This will work with the default SQL Server DATEFIRST setting & similar logic can be used to determine SUNDAY date etc. |
| |
| |
| |
|
GetUTCOffsetEURO | SQL Server 2000 | Intermediate /
Robbie Pallas | 3913 since
6/6/2005 7:08:14 AM | Unrated
|
| |
Returns the correct UTC time based on the European daylight saving Rules. |
| |
| |
| |
|
GROUP BY Date-Column | SQL Server 2000, SQL Server 7.0 | Beginner /
Boris Bjelosevic | 6278 since
6/30/2004 6:24:50 AM |
By 1 Users
|
| |
I had to present data from SQL2K on web. There was one(?) problem because data had to be grouped by date, but in the table was a field with DateTime type. At the end, I had to display all data sorted by date, so solution with Left("DateTimeField",11) woul ...(description truncated) |
| |
| |
| |
|
how many days are there in the month | SQL Server 2000 | Intermediate /
| 6572 since
9/21/2006 2:54:10 PM |
By 1 Users
|
| |
this procedure calculates the how many days are there in the month that known number of the month?
|
| |
