Adding Numbers To Date/Time Values
Posted August 4, 2006 at 2:25 PM by Ben Nadel
Ok ok, last SQL date/time post I swear. But, while testing my last entry idea, I realized you can add numbers to your date/time values. Wicked cool:
- SELECT
- -- Query for yesterday's date.
- (
- getDate() - 1
- ) AS yesterday,
-
- -- Query for tomorrow's date.
- (
- getDate() + 1
- ) AS tomorrow
Just note that this leaves in the TIME value as-is.
Reader Comments
Hi,
I need to know how to Subtract "3 days 4 hours and 22 minutes" from the current date and print the date.
@Santhosh,
Have you tried looking at the Date/Time functions built into SQL server? They must have something for it.
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 application.
@santosh you can use dateAdd function to add or subtarct date time
<cfset date=dateAdd("d",-3,now() )>
@keshav,
Thank u keshav. N also ive asked fr "3 days 4 hours and 22 minutes" in the format to be included !
Thank u keshav. N also ive asked fr "3 days 4 hours and 22 minutes" in the format to be included !
Pl suggest !
hello ben,
I need to create one exercise by using the Date function. Please help me.
Jus needed a sample query so tat i can wrk it out
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 'fri'
when '7'then 'na'
end
end
