Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Getting Daynumber in SQL Server

0 views
Skip to first unread message

Smith

unread,
Nov 15, 2006, 9:51:13 AM11/15/06
to
Hi all,

I am using SQL SErver 2000. I want to get day number in the
week from the given date like daynumber() function in power
builder. Please help me out.

Thanks in Advance,

Regards,

Ranjith T

Smith

unread,
Nov 15, 2006, 9:54:46 AM11/15/06
to
Hi All,

I worked out myself, Select datename(weekday,getdate()) will
solve the issue.

Thanks to all

0 new messages