Results 1 to 3 of 3

Thread: using getdate() in an UDF

  1. 08-07-2003, 12:35 AM #1
    bhavna
    bhavna is offline Registered User
    Join Date
    Jul 2003
    Posts
    23

    using getdate() in an UDF

    Is it right, that getdate() cannot be used in an user defined function. if so, then how do i get hte current date and time in my function?
    Reply With Quote Reply With Quote
  2. 08-07-2003, 08:28 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Rather than getting current date within the function using getdate(), pass getdate() value to the function.
    Reply With Quote Reply With Quote
  3. 08-07-2003, 10:14 AM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    declare @x datetime
    set @x=getdate()
    select * from tb1 where udfdatex(@x)=1
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules