Date 1900-01-01 00:00:00.000

SELECT 
    CASE 
        WHEN Added_Date= '1900-01-01 00:00:00.000' THEN ''
        ELSE CONVERT(VARCHAR, Added_Date, 120) -- Display the date in a specific format if it's not '1900-01-01 00:00:00.000'
    END AS FormattedDate
FROM Employee;

To display an empty string ('') when the value in a query is 1900-01-01 00:00:00.000, you can use the CASE statement to conditionally format the output. Here's an example of how you can achieve this:

SELECT 
    CASE 
        WHEN YourColumn = '1900-01-01 00:00:00.000' THEN ''
        ELSE CONVERT(VARCHAR, YourColumn, 120) -- Convert to desired date format if needed
    END AS FormattedColumn
FROM YourTable;

Replace YourColumn with the actual name of the column in your table and YourTable with the actual name of the table. This query uses the CASE statement to check if the value is '1900-01-01 00:00:00.000' and replaces it with an empty string. If the value is different, you can use the CONVERT function to format it as needed (in this case, it's converted to the ISO 8601 format with the style code 120).

SELECT 
    CASE 
        WHEN YourDateColumn = '1900-01-01 00:00:00.000' THEN ''
        ELSE CONVERT(VARCHAR, YourDateColumn, 120) -- Convert date to desired format
    END AS FormattedDate
FROM YourTable;

The problem is not at the SQL Server end. You are unlikely to have this value stored in db.

Problem is this column is either null, or is of data type string and is empty. When such is the case, it gets translated as above value in C#.

So you will have to deal with this there!

Hi

  I have written below code but it is showing NULL

case WHEN HRTST = '1900-01-01 00:00:00.000' THEN '' end 

Thanks

assume you have a table named Orders with a column named OrderDate. You want to display an empty string when the OrderDate is '1900-01-01 00:00:00.000'.

SELECT 
    CASE 
        WHEN OrderDate = '1900-01-01 00:00:00.000' THEN ''
        ELSE CONVERT(VARCHAR, OrderDate, 120) -- Formatting the date
    END AS FormattedOrderDate
FROM Orders;

SELECT 
    CASE 
        WHEN YourDateColumn = '1900-01-01 00:00:00.000' THEN ''
        ELSE CONVERT(VARCHAR, YourDateColumn, 120) -- Display the date in a different format if it's not '1900-01-01'
    END AS FormattedDate
FROM YourTable;