Search results
21 mar 2013 · In this case you can't just set a DATETIME to an empty string. Try it: SELECT CONVERT(DATETIME, ''); One workaround is to present your date as a string: CASE WHEN CONVERT(DATE, CreatedDate) = '1900-01-01' -- to account for accidental time THEN '' ELSE CONVERT(CHAR(10), CreatedDate, 120) + ' ' + CONVERT(CHAR(8), CreatedDate, 108) END
19 sty 2001 · But sometimes we try to push a blank value in the date column, which results in translating and inserting a 1900-01-01 00:00:00. The value 'Blank' (Single Quote with no value) is meant for data types which accept character data, but it is not recognized by the date or datetime data types.
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.
1 lut 2013 · 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...
Using the ISNULL() function we could write the following query which will update any row in the Product table that has a NULL value in the Color column to an empty string.
If you need it to be of the date data-type, there is a way around it, and this is to nest a REPLACE within an ISNULL, the following worked for me: Select ISNULL( REPLACE( [DATE COLUMN NAME], '1900-01-01', '' ), '') AS [MeaningfulAlias]
21 lip 2018 · The CAST() function returns a string that represents the date. The following statement returns the current date and time as a date and as a string: SELECT CURRENT_TIMESTAMP 'date' , CAST ( CURRENT_TIMESTAMP AS VARCHAR ) 'date as a string' ; Code language: SQL (Structured Query Language) ( sql )
