santhosh
Member since Aug 23, 2012
- Profile: /members/10223-santhosh.htm
- Comments: 4
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 »