Tuesday, June 14, 2005

Date conversion examples (SQL Server)

Some examples of converting dates within SQL Server: Fun with Dates (Date Conversion examples). Includes, but is not limited to - finding month when you only have week and year, last day of month, get date portion of datetime value, counting days between two dates (while excluding holidays and weekends) and get first and last day of week.

2 comments:

Anonymous said...

Well thanks for posting a link to my code. Would have been nice if you let me know about it.

Brett Kaiser

http://weblogs.sqlteam.com/brettk/

Anonymous said...

if Brett is going to be so arsey, I say dump the link, since when do you have to ask to link to someones site..?
And how can you be annoyed that somebody links to you..? Is not this how the web was built.?