Post reply

Fun with Dates

  • October 26, 2017 at 8:27 pm

    #100961

    Comments posted to this topic are about the item Fun with Dates

  • October 27, 2017 at 12:44 am

    #1965457

    Nice little puzzle to end the week on, thanks Steve.

    ...

  • October 27, 2017 at 2:02 am

    #1965465

    But why: 

    SELECT  IsNull = 'Isnull'

    ?

  • October 27, 2017 at 6:40 am

    #1965490

    Nice question to end the week on, thanks Steve

    RoNoS - Friday, October 27, 2017 2:02 AM

    But why: 

    SELECT  IsNull = 'Isnull'

    ?

    This happens when implicit conversion takes place (in this case DATE to DATETIME)
    try this:
    DECLARE @MyDate DATE, @MyDateTime DATETIME = GETDATE();
    SET @MyDate = @MyDateTime;
    IF @MyDate = @MyDateTime
    BEGIN
    SELECT "The variables match"
    END
    ELSE
    BEGIN
    SELECT "No way these variables match"
    END

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • October 27, 2017 at 8:16 am

    #1965514

    Actually, Ii think the answer should have been "The parameter @dt is the wrong data type"

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • October 29, 2017 at 5:09 pm

    #1965705

    RoNoS - Friday, October 27, 2017 2:02 AM

    But why: 

    SELECT  IsNull = 'Isnull'

    ?

    Heh... I can't know for sure because I can't read Steve's mind but I'm thinking that it was a huge hint. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply