Try_Convert Datetime showing '1/1/1900', want to show space

1 vote

1 answer

1952 views

sql-server sql-server-2016 type-conversion isnull

                          How do I get try_convert datetime to display NULL when the input is space?

I am getting two different results here. My intention is to show 'space' number query as Null also, just like first query.

    select try_convert(datetime,'abcd')   ---> Null
    
    select try_convert(datetime,'')    ---> '1/1/1900'

Asked by user173948

Mar 18, 2019, 11:21 PM
Last activity: Apr 21, 2020, 11:22 AM

Try_Convert Datetime showing '1/1/1900', want to show space

Related Questions