date manipulations Archives - Dragonsoft Technology View

SQL date operations: Last 90 days, Get Date from DateTime…

I am continuing putting some common examples of operations for Microsoft SQL Server. In addition to some of the Date related code snippets published before, there are few more today: — Last 90 days: select DATEADD(day, -90, GETDATE()) — Get Date portion of DateTime value select DATEADD(d, 0, DATEDIFF(d, 0, Read more

By Serguei Dosyukov, 18 yearsMay 12, 2008 ago

Fun stuff with SQL Server

SQL date operations: First day, Last day of the month…

Did you ever faced a situation when you need quickly calculate some boundaries of the Date value like First Day of the month, Last Day of the month, etc… in T-SQL? Colegue of mine asked me this question… WOW! What do you know… It is actually very easy if we think Read more

By Serguei Dosyukov, 18 yearsFeb 5, 2008 ago

Testimonials

Long standing GD Theme user. The GD Theme is very user friendly. I was able to create a fantastic gallery for my website using some of the many, many, options GD Theme offers. Thanks for the hard work and dedication to your theme and for allowing us the opportunity to Read more

― Gene S. Salisbury, President

The greydragon theme is fantastic. It’s clean, stable and feature rich. It took me a while to decide to move to G3 but with a there like this one, I could no longer resist. Thanks!

― Ed