Search results
21 mar 2013 · 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 · 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.
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.
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.
8 sty 2014 · Run SQL queries in Excel interface and directly on Excel tables. Generate SELECT and JOIN statements automatically. Use JOIN, ORDER BY, DISTINCT, GROUP BY, SUM and other SQLite operators. Write queries in the intuitive editor with syntax highlighting. Address any Excel tables from a tree list view.
INSERT INTO [dbo].ProductionSELECT [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.
11 kwi 2015 · The best format to insert a date time into a datetime column is to present the date and time as YYYY-MM-DD Minute:Second or 2015-04-15 12:52. so to insert a datetime from Excel you can use this set of Excel functions: (where A1 contains the datetime to be saved)
