Re: SQL Minus 7 days from current date



On Mon, 30 Apr 2007 10:06:00 -0700, RFrechette wrote:

Hi Hari,

I'm sorry I didn't explain myself very well.

What I was trying to do was get all files that are 7 days older than today.

Hi Rachel,

SELECT oss_tran,acctno, oss_tran.[date]
FROM oss_tran
WHERE oss_tran.[date] >= DATEADD(day, -7, CURRENT_TIMESTAMP);

* Note that I used DATEADD instead of the non-standard method of
substracting a number from a datetime, and that I used CURRENT_TIMESTAMP
instead of the undocumented GETDATE().

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
.



Relevant Pages

  • Re: SQL Humor
    ... Hugo Kornelis wrote: ... SQL Server will often produce the same execution for both versions. ... the big questions for the RM, *for me* seem to include view updatability which has to do with the operators of the algebra as well as whether a relational engine can implement customary features such as concurrency control and presentation coherence without being written in a language that eschews the relational operators. ...
    (comp.databases.theory)
  • Re: Help with missing data in query
    ... I did go to that site But I couldn't figure out how to upload anything. ... GROUP BY m.MonthName WITH ROLLUP ... Hugo Kornelis, SQL Server MVP ...
    (microsoft.public.sqlserver.mseq)
  • Re: How to Gnerate a Random ID Number
    ... formula with a seed as input to get at a pseudo-random value?) ... that definitely rules out newid() as a "good" pseudo random number ... this on SQL Server 2005, and the seed does not seem to be reset (or at ... Hugo Kornelis, SQL Server MVP ...
    (comp.databases.ms-sqlserver)
  • Re: Not passing back values on an if statement
    ... Hugo Kornelis wrote: ... SQL Server has to check not only that a row ... > column Application doesn't allow NULLs, ... This email account is my spam trap so I ...
    (microsoft.public.sqlserver.programming)
  • Re: mssql: insert into syntax
    ... Hugo Kornelis writes: ... > Your mention of preserving order when rows are deleted makes me think ... INSERT tbl ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)