Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFinNC 2009 (Raleigh, North Carolina) with: Simon Free and Todd Sharp and Shannon Hicks and Charlie Arehart and Sean Corfield and Jason Dean
Ben Nadel at CFinNC 2009 (Raleigh, North Carolina) with: Simon Free@simonfree ) , Todd Sharp@cfsilence ) , Shannon Hicks@iotashan ) , Charlie Arehart@carehart ) , Sean Corfield@seancorfield ) , and Jason Dean@JasonPDean )

imransi

Member since Jun 4, 2010

Recent Blog Comments By imransi

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Jun 7, 2010 at 4:06 PM

    No, single quotes will not work. the error is from line 1. following is what i am trying to do. Example: Column1 Column2 2009-01-08 19:42:00.000 2009-08-01 19:42:00.000 Also, I don't know the code to update just the month and also just the day with in a datetime column. Please... read more »

  • Getting Only the Date Part of a Date/Time Stamp in SQL Server

    Posted on Jun 4, 2010 at 12:25 PM

    I need a lill help from you all smartys! I am working on an update of a datetime field and receiving the following error. Query: Update tbl SET Month(column 1) = Month(Column 2), Day(column 1) = Day(column 2) WHERE Month(column 1) = Day(column 2) and Day(column 1) = Month(column 2) and id in (111... read more »