TAG | Transact-SQL
Jan/07
26
SQL Server: MaximumDate() Function
No comments · Posted by Craig Buchanan in Programming, SQL Server
A SQL Server, scalar-value function that returns the greater of two dates. (more…)
Jan/07
26
SQL Server: MinimumDate() Function
No comments · Posted by Craig Buchanan in Programming, SQL Server
A SQL Server, scalar-value function that returns the lessor of two dates. (more…)
May/06
25
Sql Server: DateRanges() Function
No comments · Posted by Craig Buchanan in Functions, Programming, SQL Server
This user-defined function creates a table of date ranges. (more…)
The Sql Server GETDATE() function not allowed in the body of user-defined functions, as it is non-deterministic. The GetNow view provides a means to generate a system date/time that can be used in Sql Server user-defined functions.
