Path: csiph.com!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Erland Sommarskog <esquel@sommarskog.se>
Newsgroups: microsoft.public.sqlserver.programming
Subject: Re: How to add a datetime column for a 24 hour period
Date: Thu, 26 Oct 2017 20:58:26 +0200
Organization: Erland Sommarskog
Lines: 8
Message-ID: <XnsA81AD55BF8993Yazorman@127.0.0.1>
References: <d0c629ca-5826-4cd4-baba-9848a915df19@googlegroups.com> <XnsA817F2C2824FCYazorman@127.0.0.1> <9ebb76da-7445-4b19-a786-49e159c79594@googlegroups.com> <XnsA818D3EA567D3Yazorman@127.0.0.1> <d2765dc6-eb6b-46ef-9a89-d2f6c80d70f8@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 8bit
Injection-Info: reader02.eternal-september.org; posting-host="08662bffeee648e95705855131d3b702"; logging-data="28657"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX19KR2ytlMmnq2s3WPt1bITc"
User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock: sha1:keLQqDrv301lBypLAwwkbI7/e3U=
Xref: csiph.com microsoft.public.sqlserver.programming:31336

Mike Arney (mikespcnet.net@gmail.com) writes:
> How can I get the last 24 hours of "OnTime" from "NOW"?
> 

Timestamp > dateadd(HOUR, -24, sysdatetime())

-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se