Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at cf.Objective() 2013 (Bloomington, MN) with:

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 »