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
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 · The solution is in-fact a workaround or a quick fix than a total solution, since a blank date can be either a NULL or 1900-01-01. However, converting the date into a string does relieve us from showing irrelevant data to our clients. Date and Time are not character values and therefore, you must handle it carefully. ← Previous
18 paź 2011 · The closest thing I can think of is the Excel function =NA(). This works the way NULL does in SQL in that adding a cell containing NA() to a cell containing a value returns NA().
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.
I have the following code that returns the needed data into excel and manually changing the date will change the returned data; however, I'd like to reference a cell with a formula that will make the query a bit more user friendly.
25 sty 2022 · Try Data > Get Data > From Other Sources > From Table/Range. Excel will probably convert the values to its own date/time format automatically. Alternatively, with such a value in D2 and down, enter the following formula in another cell in row 2, then fill down: =DATE(LEFT(A2,4),MID(A2,6,2),MID(A2,9,2))+TIMEVALUE(MID(A2,12,12))
