Post reply

Replace datetime column with null as empty string

  • February 1, 2013 at 8:02 am

    #273755

    hi,

    I have a query as below

    select ISNULL([HIRE_VEHICLE_REGISTERED_DATE],'') from WIP_INVOICE_HEADER

    This returns the output as 1900-01-01. But i need an empty string if the value in the column is null.

    how can i get that?

    Please help....

  • February 1, 2013 at 8:05 am

    #1583462

    You will need to convert the column to a string.

    If you tell SQL to use '' as a datetime column you will get 1900-01-01 as that is the default date and the default way SQL works.

  • February 1, 2013 at 8:17 am

    #1583466

    Hi

    If you see my entire sql it will be a coalesce of many columns. In that one is a datecolumn and i do the following

    COALESCE(CAST(ISNULL(IH.[HIRE_VEHICLE_REGISTERED_DATE],'')AS VARCHAR) + ',', '')

    When i do export,

    Only empty values were comma sepearted and null values are not.

    so i do a null check and to replace all null values with empty string.

  • February 1, 2013 at 8:19 am

    #1583468

    Convert the column before doing the ISNULL check

    ISNULL(CONVERT(varchar, datecolumn),'')

  • February 1, 2013 at 8:27 am

    #1583471

    Thanks 🙂 it worked

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

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