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 the New York ColdFusion User Group (Mar. 2009) with: Aaron Foss

santhosh

Member since Aug 23, 2012

Recent Blog Comments By santhosh

  • Adding Numbers To Date/Time Values

    Posted on Aug 28, 2012 at 3:10 AM

    Hi, This was the question: "If the day is (Mon/Wed/Fri) print 'Date is Mon/Wed/Fri' " THE ANSWER: create procedure exe @da_Yl date as begin select day=case DATEPART(DW,@da_Yl) when '1'then 'na' when '2'then 'monday' when '3'then 'na' when '4'then 'wednes' when '5'then 'na' when '6'then... read more »

  • Adding Numbers To Date/Time Values

    Posted on Aug 26, 2012 at 11:41 PM

    Thank u keshav. N also ive asked fr "3 days 4 hours and 22 minutes" in the format to be included ! Pl suggest !... read more »

  • Adding Numbers To Date/Time Values

    Posted on Aug 24, 2012 at 1:03 AM

    Hi, I have tried using date functions. But couldn't find exact. The thing is if I type the date as such 24-08-2012 the output shd be 21-08-2012. It shd be applicable for all the dates !! Note : 3 days 4 hours and 22 minutes shd be included I need the query for the scenario as its imp for one appl... read more »

  • Adding Numbers To Date/Time Values

    Posted on Aug 23, 2012 at 7:40 AM

    Hi, I need to know how to Subtract "3 days 4 hours and 22 minutes" from the current date and print the date.... read more »