|
|
Posted by Ed Murphy on 10/02/34 11:54
On Wed, 02 Aug 2006 12:38:39 GMT, "Dan Guzman"
<guzmanda@nospam-online.sbcglobal.net> wrote:
>> 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
Eww, magic numbers! And isn't Roy's solution using DatePart() and
DateAdd() a lot cleaner than converting to and from char?
Navigation:
[Reply to this message]
|