Search results
21 mar 2013 · I want to display an empty string if the field is the minimum date (1/1/1900), but my CASE statement doesn't work; CreatedDate displays 1900-01-01 00:00:00.000 in my query when that value is in the database. I'm using SQL Server 2008 R2.
23 sie 2013 · Excel has the correct value of the DATETIME (even if the formatting is applied after the paste), but by default doesn't have a built in format to show the SQL DATETIME. Here's the fix: Right click the cell, and choose Format Cells.
19 sty 2001 · Since, we cannot insert a blank value instead of 1900…, we will use a workaround so we can at least display a blank value instead of a value that shows the date from another era. We will write a simple query, which will convert 1900-01-01 into a meaningful value.
9 maj 2022 · I want to pull the formula down so that it automatically shows the date in columns A and B if there is a date in column C; however, I do not want it to say 1900 on blank cells. Columns A and B pull from C (are not manually entered) as shown in the image below: A and B use this formula: A is =TEXT(C27,"YYYY") B is =TEXT(C27,"MMM") .
17 lis 2015 · You can't get an empty string because you're returning the DATE value type from ISNULL. Per the docs, ISNULL. Returns the same type as check_expression. If a literal NULL is provided as check_expression, returns the datatype of the replacement_value.
SQL Server comes with the following data types for storing a date or a date/time value in the database: DATE - format YYYY-MM-DD. DATETIME - format: YYYY-MM-DD HH:MI:SS. SMALLDATETIME - format: YYYY-MM-DD HH:MI:SS. TIMESTAMP - format: a unique number.
Consider the following code in Microsoft SQL Server 2012: INSERT INTO [dbo].Production SELECT [field1] ,[field2] ,cast([datefield] as datetime) FROM [RAW].Staging The staging table is loaded with data from a CSV file. So in some cases, rather than having NULL fields we end-up with empty fields.
