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() 2010 (Minneapolis, MN) with:

Adding Numbers To Date/Time Values

By Ben Nadel on
Tags: SQL

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.

Tweet This Deep thoughts by @BenNadel - Adding Numbers To Date/Time Values Thanks my man — you rock the party that rocks the body!


Reader Comments

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.

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