Post reply

ISNULL for datetime

  • May 21, 2007 at 2:24 am

    #117289

    Hi,

        i need help on this.How can i handle the isnull for column Assessed_Date

    Select

    sl

    .School_Name,

    isnull(mc.Assessed_Value,'')as Assessed_Value,

    isnull(mc.Assessed_Date,'') as Assessed_Date

     

    From APPN_Building_List bl

    left outer join FMPS_Building_Cost mc on (bl.Building_Id= mc.Building_Id)

    left outer join APPN_School_List sl on (bl.school_id = sl.school_id)

     

    i get the results as follows

    School_Name                 Assessed_Value           Assessed_Date

    Morris                              0.00                         1900-01-01 00:00:00.000

    Ralph Talbot                      0.00                        1900-01-01 00:00:00.000

    Hemenway                        0.00                         1900-01-01 00:00:00.000

     

     

  • May 21, 2007 at 2:34 am

    #707752

    Convert the date to a varchar then the isnull will do what you want it to.  Or you can always let the application handle the nulls when displaying the data.

  • May 21, 2007 at 2:55 am

    #707755

    Thanks a lot for the suggestion it worked

Viewing 3 posts - 1 through 3 (of 3 total)

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