Groups > microsoft.public.sqlserver.programming > #31337

Re: How to add a datetime column for a 24 hour period

X-Received	by 10.200.6.196 with SMTP id j4mr2924526qth.60.1509641679955; Thu, 02 Nov 2017 09:54:39 -0700 (PDT)
X-Received	by 10.31.161.87 with SMTP id k84mr313395vke.7.1509641679601; Thu, 02 Nov 2017 09:54:39 -0700 (PDT)
Path	csiph.com!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!k31no963530qta.1!news-out.google.com!v14ni2153qtc.0!nntp.google.com!k31no963529qta.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	microsoft.public.sqlserver.programming
Date	Thu, 2 Nov 2017 09:54:39 -0700 (PDT)
In-Reply-To	<XnsA81AD55BF8993Yazorman@127.0.0.1>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=216.234.125.194; posting-account=4nS5WwoAAACio8l9etd0ayIsc32V0GtK
NNTP-Posting-Host	216.234.125.194
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> <XnsA81AD55BF8993Yazorman@127.0.0.1>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<9261dd0f-8f04-4810-a19a-a210e4bd9ad6@googlegroups.com> (permalink)
Subject	Re: How to add a datetime column for a 24 hour period
From	Mike Arney <mikespcnet.net@gmail.com>
Injection-Date	Thu, 02 Nov 2017 16:54:39 +0000
Content-Type	text/plain; charset="UTF-8"
Lines	12
Xref	csiph.com microsoft.public.sqlserver.programming:31337

Show key headers only | View raw

On Thursday, October 26, 2017 at 2:58:29 PM UTC-4, Erland Sommarskog wrote:
> 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

Thank you Erland! This was a tremendous help for my project.

Mike

Back to microsoft.public.sqlserver.programming | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

How to add a datetime column for a 24 hour period Mike Arney <mikespcnet.net@gmail.com> - 2017-10-23 11:42 -0700
  Re: How to add a datetime column for a 24 hour period Erland Sommarskog <esquel@sommarskog.se> - 2017-10-23 23:51 +0200
    Re: How to add a datetime column for a 24 hour period Mike Arney <mikespcnet.net@gmail.com> - 2017-10-24 05:10 -0700
      Re: How to add a datetime column for a 24 hour period Mike Arney <mikespcnet.net@gmail.com> - 2017-10-24 05:12 -0700
    Re: How to add a datetime column for a 24 hour period Mike Arney <mikespcnet.net@gmail.com> - 2017-10-24 05:38 -0700
      Re: How to add a datetime column for a 24 hour period Erland Sommarskog <esquel@sommarskog.se> - 2017-10-24 20:49 +0200
        Re: How to add a datetime column for a 24 hour period Mike Arney <mikespcnet.net@gmail.com> - 2017-10-25 04:57 -0700
          Re: How to add a datetime column for a 24 hour period Erland Sommarskog <esquel@sommarskog.se> - 2017-10-26 20:58 +0200
            Re: How to add a datetime column for a 24 hour period Mike Arney <mikespcnet.net@gmail.com> - 2017-11-02 09:54 -0700
              Re: How to add a datetime column for a 24 hour period mikespcnet.net@gmail.com - 2018-05-08 08:21 -0700
                Re: How to add a datetime column for a 24 hour period Mike Arney <mikespcnet.net@gmail.com> - 2018-05-08 08:35 -0700
                Re: How to add a datetime column for a 24 hour period Erland Sommarskog <esquel@sommarskog.se> - 2018-05-08 19:48 +0200
                Re: How to add a datetime column for a 24 hour period Mike Arney <mikespcnet.net@gmail.com> - 2018-05-09 06:31 -0700
                Re: How to add a datetime column for a 24 hour period Mike Arney <mikespcnet.net@gmail.com> - 2018-05-09 06:34 -0700
                Re: How to add a datetime column for a 24 hour period Erland Sommarskog <esquel@sommarskog.se> - 2018-05-09 23:08 +0200

csiph-web