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

I’ve used your Greydragon theme ever since I switched to using Gallery3. It looks very slick; it does everything that I want; it is easy to customise the appearance with its many options; image preloading makes it faster than other themes; the author continually develops it in response to feature Read more

― Brian Stewart

I’m a huge fan of this theme. I’ve got more than 90,000 pictures in my gallery3 running on a Ubuntu 11.10 desktop. It’s only for family photos. The GD theme is by far the most polished theme, easy to use and it’s still being developed! The theme options made me Read more

― Jklobo