Adding Numbers To Date/Time Values

Posted August 4, 2006 at 2:25 PM by Ben Nadel

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.

Reader Comments

There are no comments posted for this web log entry.

Post A Comment

: Please do not post spam. Please keep the comments on-topic. Please do not post unrelated questions or large chunks of code. And, above all, please be nice to each other - we're trying to have a good conversation here.

Author Name:
Author Email:
Author Website:
Comment:	Supported HTML tags for formatting: <strong>bold</strong> <em>italic</em> <code>code</code>
	Remember my information
	Subscribe to comments
	Send me a copy of this comment

InVision App - Prototyping Made Beautiful With Prototyping Tools Ben Nadel's Company - Epicenter Consulting

Bartezz

Feb 10, 2012 at 7:21 PM

jQuery AJAX Strips Script Tags And Inserts Them After Parent-Most Elements

Update! Instead of $(eval(options.insertAfter)).after(data['insertData']); I now use: var ajaxNode = document.createElement('span'); var parent = $(eval(options.insertAfter))[0].parentNode; ... read »

Bartezz

Feb 10, 2012 at 6:18 PM

jQuery AJAX Strips Script Tags And Inserts Them After Parent-Most Elements

encountered this same, what I consider, jQuery bug last week. I'm building a site in which I load some content via AJAX. This content contains Linkedin share button placeholders which Linkedin API ne ... read »

Drew Wells

Feb 10, 2012 at 11:30 AM

Cross-Origin Resource Sharing (CORS) AJAX Requests Between jQuery And Node.js

After you understand the concepts here, this is an awesome cheatsheet for enabling CORS in just about anything http://enable-cors.org/ ... read »

Feb 10, 2012 at 9:10 AM

My Safari Browser SQLite Database Hello World Example

@Amy, Here is a very good tutorial on how to use JOIN: http://www.sqltutorial.org/sqljoin-innerjoin.aspx ... read »

Stefan Richter

Feb 10, 2012 at 4:42 AM

Building A Twitter-Inspired RESTful API Architecture In ColdFusion

This is great, very useful Ben. I spotted a small typo in the api.cgm listing: <cfthrow type="Unauthroized" /> Cheers Stefan ... read »

Hugh

Feb 9, 2012 at 10:35 PM

CFDirectory Filtering Uses Pipe Character For Multiple Filters (Thanks Steve Withington)

I was wondering if there would be a filter you could apply so that you got everything but what you included in the filter. As in show me all docs that are not a .pdf. ... read »

Stephen

Feb 9, 2012 at 10:29 PM

Learning ColdFusion 9: Application-Specific Data Sources

@Ben, No offence, but if people were really wanting advanced features they would be using a platform like ASP.NET MVC. CFML is so structurally compromised as a tag-based scripting language that ... read »

Nathan

Feb 9, 2012 at 10:03 PM

Subversion - Cleanup Failed To Process The Following Paths

@Leviaguirre, do you still have problems with this? ... read »