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, 17 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

First I’m new to G3. I was wanting to append my forum with a gallery and after doing a lot of looking and testing I settled on G3.I tried all the themes I could find on the page at the mothership (Gallery homepage). I settled on graydragon. It’s so close Read more

― Setishock

I’ve been using this [theme] since the start. It is by far the most attractive, feature packed and stable of the user-created skins for Gallery3.

― Rhyull