Skip to main content

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 »

I believe in love. I believe in compassion. I believe in human rights. I believe that we can afford to give more of these gifts to the world around us because it costs us nothing to be decent and kind and understanding. And, I want you to know that when you land on this site, you are accepted for who you are, no matter how you identify, what truths you live, or whatever kind of goofy shit makes you feel alive! Rock on with your bad self!
Ben Nadel