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.


$19.95 for one copy of the functions for installation on one database server.

Join Our E-Mail Newsletter

For Email Newsletters you can trust

Sister Sites

RiteTech LLC
Modern HOA