Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  date part returns 3 how so i get "Mon"

Author  Topic  plocke Starting Member 15 Posts Posted - 2001-11-13 : 11:54:48 select datepart(Dy,@dayofdaniel)as day will give me "3" is there a function it make it "Tue" or "Tuesday" ?