I want some Moore

Blog about stuff and things and stuff. Mostly about SQL server and .Net
posts - 219, comments - 2287, trackbacks - 33

My Links

Advertisement

News

Hi! My name is 
Mladen Prajdić  I'm from Slovenia and I'm currently working as a .Net (C#) and SQL Server developer.

I also speak at local user group meetings and conferences like SQLBits and NT Conference
Welcome to my blog.
SQL Server MVP

My Books

SQL Server MVP Deep Dives 2
The Red Gate Guide to SQL Server Team based Development Free e-book

My Blog Feed via Email
Follow MladenPrajdic on Twitter


Users Online: who's online

Article Categories

Archives

Post Categories

Cool software

Other Blogs

Other stuff

SQL stuff

SQL Server Date and Time fun from all around

A few days ago Adam Machanic proposed a great idea about a T-SQL Tuesday. Every Tuesday there would be a topic bloggers all around would post about. Chosen as the first topic was the date and time stuff in SQL Server.

Because there’s already all this great content out there I’m not going to repeat it but I’m going to put together a ton of datetime resources from SQLTeam forums and blogs as a resource you can use in the future.

 

Michael Valentine Jones

MVJ as we like to call him in the forums has a thing for datetime manipulation. He has some really good helper functions he shared with the world.

 

Peter Larsson

Peter is an MVP who has the most amazing ideas for writing SQL. If you want performance talk to him.

 

Jeff Smith

Sometimes I think that Jeff is datetime machine. His posts are always high quality and simple to understand. He’s also an MVP who I hope will start blogging more again soon.

 

K H Tan

K H Tan is a smart fellow from Singapore who’s always glad to help. Shame he doesn’t blog.

  • fn_next_business_day - Calculates the next x business day (excluding Sat, Sun). Basically a businessdateadd() for dateadd()

 

Mladen Prajdić

In each post I learned something new or got a nice idea so it’s also worth reading the comments. On some issues my views have changed while on others they stayed the same.

Print | posted on Tuesday, December 08, 2009 6:41 PM | Filed Under [ SQL Server Back to Basics ]

Feedback

Gravatar

# re: SQL Server Date and Time fun from all around

One correction: NOT every Tuesday. That would be way too much work for everyone :-) ... Only the 2nd Tuesday of each month.
12/8/2009 7:46 PM | Adam Machanic
Gravatar

# re: SQL Server Date and Time fun from all around

really? not every tuesday? that's totally disappointing! :)
12/8/2009 9:46 PM | Mladen
Gravatar

# re: SQL Server Date and Time fun from all around

2nd tuesday corresponds to patch tuesday - that could also be pretty busy for a lot of people.



-ec
12/9/2009 1:04 AM | eyechart
Gravatar

# re: SQL Server Date and Time fun from all around

eyechart: I was unaware of that--not an IT guy--and it is a good point, but it doesn't really matter. People can (and should) write blog posts in advance and schedule them to go live when they want them to. This will give bloggers, especially in IT, a chance to practice organizational skills :-)
12/9/2009 5:11 AM | Adam Machanic
Gravatar

# re: SQL Server Date and Time fun from all around

Thanks for the useful links!
12/9/2009 3:46 PM | John Sonmez
Gravatar

# re: SQL Server Date and Time fun from all around

This might help users with reporting services. This link shows how to use date functions to set parameters inside of reporting services reports: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99697

Enjoy
12/11/2009 4:07 PM | Jon H
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET