Sql function

I ahve the function in sql "lastbusinessday " 
but How can I get the value from that function
peterstiAsked:
Who is Participating?
 
Imran Javed ZiaConnect With a Mentor Consultant Software Engineer - .NET ArchitectCommented:
by name it seems to be a method to return last working day or date you you may use it as

select lastbusinessday()

and it will return you date or day
0
 
sventhanCommented:
select lastbusinessday parameter -- pass the parameter if you have any

if not just

select lastbusinessday
0
 
Lee SavidgeCommented:
It depends on what that function does. What parameters does it take?

0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
gskaccountCommented:
simply u can use
Select * from lastbusinessday
or
Select * from lastbusinessday('parameter value') --if you hae any parameter
0
 
Imran Javed ZiaConsultant Software Engineer - .NET ArchitectCommented:
if this function returns a table then you can use

select * from dbo.lastbusinessday (parameter)

and if it is a scalar value function then you may use it in some query as field

select dbo.lastbusinessday (parameter)
or
select dbo.lastbusinessday (parameter), * from your table
0
 
peterstiAuthor Commented:
solution is good
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.