Posted by Dan Guzman on 10/15/19 11:54

> I need to add 48 hours to a specific date (datetime data type) then
> check if the time is past 5pm.

I don't fully understand your requirements and how this problem relates to
your subject but the example below should get you started.

DECLARE
@datetime1 datetime,
@datetime2 datetime

SET @datetime1= '20060802 19:00:00'

--compare only time portion
IF CAST(CONVERT(char(8), @datetime1, 114) AS datetime) > '17:00:00'
BEGIN
--after 5pm: make the time 5pm and add 2 days
SET @datetime2 = CAST(CONVERT(char(8), @datetime1, 112) + ' 17:00:00' AS
datetime) + 2
END
ELSE
BEGIN
--5pm or earlier: leave time unchanged add 2 days
SET @datetime2 = @datetime1 + 2
END
SELECT @datetime1, @datetime2

--
Hope this helps.

Dan Guzman
SQL Server MVP

<simon_s_li@hotmail.com> wrote in message
news:1154514095.177638.37030@b28g2000cwb.googlegroups.com...
> Hi,
>
> I need to add 48 hours to a specific date (datetime data type) then
> check if the time is past 5pm.
>
> So for example the time is 7pm.
>
> If this is the case I need to set the time to 5pm the next where the
> final date and time will be set to a new datetime variable.
>
> Can anyone help??
>
> Examples would be great.
>
> Regards
> Simon
>

[Back to original message]