Post reply

SQL Server Development

  • February 10, 2010 at 12:37 am

    #100097

    Hi

    I have a query wrt comparing two datetime values.

    i have a query:

    Select Count(1) Records From tblA

    Where Convert(Varchar(10),Row_Insert_Date,103) <= Convert(Varchar(10),GetDate(),103)

    I have few doubts regarding this:

    1. Should we / Should'nt we use Convert. Explanation will be greatly appreciated.

    2. What is the best way to compare dates.

    Thanks

    Azeem.

  • February 10, 2010 at 1:27 am

    #1116612

    I had a similair question some time ago - http://www.sqlservercentral.com/Forums/Topic731245-338-1.aspx

    BrainDonor

    Steve Hall
    Linkedin
    Blog Site

  • February 10, 2010 at 1:45 am

    #1116618

    Thank you. I went through the thread and found it very useful. Still my doubts persist as to what is the better alternative.

    Thanks Again.

    Azeem.

  • February 10, 2010 at 2:57 am

    #1116645

    If your date formats are consistant across your servers and databases then why bother formatting them? I've had to do it in the past to remove the time element, or because we've had a mixture of date formats (due to having US customers talking to our UK servers/databases), but otherwise I tend not to bother.

    As the post I linked to showed, it will slow the query down and if its not required its just more code to read through.

    Personally I'd have a play with it to see if there is any negative impact from removing all of the formatting. If you still get the correct results then do without.

    BrainDonor.

    Steve Hall
    Linkedin
    Blog Site

  • February 10, 2010 at 3:11 am

    #1116649

    Hi

    How to compare Column values with user provided variables.

    Select 1 From tbla Where RID = '13/12/2009'

    or range

    Select 1 From tbla Where RID between '13/12/2009' and '16/12/2009'

    The column contains date and time.

    Thanks

    Azeem

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

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