Wednesday, February 21, 2024

how to pass parameter of stored procedure or parameter of function as datetime

 select dbo.Age (convert(varchar, '01/02/2000',105) )  -- date as mm/dd/yyyy



ref:- https://stackoverflow.com/questions/8694503/how-to-pass-the-datetime-value-as-parameter-to-a-stored-procedure

No comments:

Post a Comment