Re: How do I always return Sunday of previous week. Sun - Sat.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Uri Dimant (urid_at_iscar.co.il)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 10:27:02 +0200

Lam
declare @dt as datetime
set @dt='20040823'
select dateadd(day,datediff(day,'19000101',@dt)/7*7-1,'19000101')

"Lam Nguyen" <nguyen.lam@aaa-calif.com> wrote in message
news:2d4001c47e5b$875bf190$a301280a@phx.gbl...
> How do I get the previous Sun. Example if today Monday
> then I should previous week from Sun 8/1 - 8/7 Sat.
> The week start on Sunday and end on Sat of previous week.
> Thanks in advance.
>
> DECLARE @cDate DATETIME,
> @prevMonday DATETIME,
> @prevSunday DATETIME,
> @prevSat DATETIME
> SET @cDate = GETDATE()
> SELECT @cDate AS 'CurrentDate'
> --SET DATEFIRST 1
> SET @prevSunday = DATEADD(DAY , (-1 * DATEPART(dw,
> (@cDate - 1))), @cDate)
> SELECT @prevSat = CONVERT(CHAR(10), DATEADD(DAY, (0 -
> DATEPART(dw, CURRENT_TIMESTAMP )), CURRENT_TIMESTAMP), 101)
> SELECT @prevSunday AS 'PrevSunday', @prevSat AS 'PrevSat'
> GO
>
> Lam

Relevant Pages

  • Re: Spalten alternativ ansprechen
    ... DECLARE @Monat INT ... '01' AS DATETIME) ... case when DATUM between '...' ... then UMSATZ as ...
    (microsoft.public.de.access.clientserver)
  • Re: a view based on stored procedure
    ... DECLARE @Week_1 DATETIME ... DECLARE @CubeTime DATETIME ... INSERT INTO WrkAvailPlanHours ...
    (microsoft.public.sqlserver.programming)
  • Re: Language problem
    ... @datum datetime ... > Then in application I have settings of my connection: ... > everything else doesn't because all other functions are set to slovenian. ... > DECLARE @dt DATETIME,@datumMesec dateTime,@datumTedenZ datetime,@datumTedenK ...
    (microsoft.public.sqlserver.programming)
  • RE: User Defined Function Help
    ... @startDateTime datetime = null, ... DECLARE @selectFromList varchar ... SET @subservice = RTRIM ... EXEC ...
    (microsoft.public.sqlserver.programming)
  • Re: get time in SQL server
    ... >conversion to datetime data type but could not do it. ... >declare @date2 as datetime ... declare @date1 varchar ...
    (microsoft.public.sqlserver.server)