Date 1900-01-01 00:00:00.000

Question

Hi In a query if value is 1900-01-01 00:00:00.000 then '' should be displayed. Thanks

Nitin Sontakke · Answer

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!

Cr Bhargavi · Answer

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;

Ramco Ramco · Answer

Hi I have written below code but it is showing NULL case WHEN HRTST = '1900-01-01 00:00:00.000' THEN '' end Thanks

Mohammad Hussain · Answer

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;

Saravanan Ganesan · Answer

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 ).

Tahir Ansari · Answer

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;

Anandu G Nath · Answer

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;

Date 1900-01-01 00:00:00.000

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (7)