T-SQL Tip: How to Use GETDATE() in User Defined Function

Seems you it is impossible to use GETDATE() to get the current date in MSSQL user defined function because of determinism, i.e. GETDATE() will always return different values. However it is possible to get the desired functionality with the help of the following little trick. We can create a view and use GETDATE() in a view. Later our user defined function will query this view.

CREATE VIEW V_DATE
AS
SELECT GETDATE() VAL

user defined function will look like so:

SELECT VAL FROM V_DATE

HTH

Related Posts:

• T-SQL: Search Logic
• T-SQL DATETIME : Last Day of the Month
• Small T-SQL trick
• How to Insert Millions Records into Database Table
• T-SQL: Update and Output in a Single Query
• MSSQL 2005 beta 2 DE first impressions
• MSSQL Overusability
• SQL Server 2005 Developer Edition Beta 2 (English)
• MSSQL 6.5 Service Pack 5 is Available
• SQL Server 2005 Documentation and Samples