Entries for month: July 2009

SQL Selecting the Last Day of a Month

SQL - Author:John Gag at 5:53 PM No Comments »

I think SQL does a pretty good job with dates.  Here is a very simple way to get the last day of any month.  The example retreaves the last day of the last month.


SELECT DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))

 

Replace the GETDATE() with whatever date you need to find the last day of the month before.

Read more...

ColdFusion 9 New Features Review by SitePoint

ColdFusion - Author:John Gag at 12:26 PM 2 Comments »

Here is a link to a cool ColdFusion 9 review by the guys over at SitePoint. 

http://www.sitepoint.com/article/whats-new-coldfusion-9/

Read more...

Public Beta ColdFusion 9 Builder Now Available

ColdFusion - Author:John Gag at 9:12 AM 1 Comment »

You can now download the public beta ColdFusion 9 Builder here:

http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_coldfusionbuilder

Read more...

Powered by Mango Blog. Design and Icons by N.Design Studio
RSS Feeds