Custom T-SQL Date Functions
Bringing the power and ease of ColdFusion's built-in functions to SQL Server!
The WebTricks Custom T-SQL Date Functions are custom/user-defined functions for SQL Server that mimic both the functionality and syntax of 20 ColdFusion date/time functions.
These functions are not only useful for easily returning formatted values directly from the database, they are also a great learning tool as many of them contain complex and advanced T-SQL code and are unencrypted and well commented.
For full usage information and examples please check out the User/Developer Guide!
The following date/time functions are included:
- CreateDate
- CreateDateTime
- CreateTime
- DateCompare
- DateFormat
- DayOfWeek
- DayOfWeekAsString
- DayOfYear
- DaysInMonth
- DaysInYear
- FirstDayOfMonth
- Hour
- IsLeapYear
- Minute
- MonthAsString
- ParseDateTime
- Quarter
- Second
- TimeFormat
- Week
*** These functions are for Microsoft SQL Server only.
Pricing
$19.95 for one copy of the functions for installation on one database server.