sjuarez1979
Programmer
Is there a way to have a variable (IE @Var) in a stored procedure acquire the current date?
sjuarez1979
sjuarez1979
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Retrieve Current Date Using SQL
- Thread starter sjuarez1979
- Start date
- Status
- Thread starter
- #2
sjuarez1979
Programmer
Ok, so I guess I'm smarter than I thought. I guess the little help menu works. This is how it works:
SELECT @NowDate = GetDate()
Is there a good place where all of the functions of that sort are listed?
sjuarez1979
SELECT @NowDate = GetDate()
Is there a good place where all of the functions of that sort are listed?
sjuarez1979
tlbroadbent
MIS
Yes. Look up functions in SQL Books Online. Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)
Home of the 2002 Winter Olympics (Feb 8-24)
- Status
Similar threads
- Locked
- Question
