Search results
21 mar 2013 · lhd.CreatedDate is a DateTime field and is non-nullable. 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.
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.
17 lis 2015 · If you're checking whether or not the value is NULL, there is no need to convert it to a date, unless you wanted to return a date value (which you don't seem to). Instead, use: SELECT ISNULL( DOB , '') Which will return '' if the value is NULL. A NULL date is NULL (no value).
17 maj 2021 · Numbered items below in green are working just fine, items in red are what I'm having issues with: L7 has formula =N7-M7. However, I want for cells in that column to be blank when N7 and/or M7 are empty. Then, when user enters the values for N7 and M7, it provides calculated dates for L7 and J7.
7 sie 2017 · Learn to create an Excel SQL Query and get data directly from the source! Three different approaches to write custom SQL Queries in Excel.
29 mar 2016 · You can use instead of ORDER_HIST_LINE.DATE_SHIPPED select ....convert(ORDER_HIST_LINE.DATE_SHIPPED, getdate(), 103) For 103 it is the format or type of date you can choose from this example which number you need.
10 sty 2024 · How do you export data from an SQL database to Excel or another spreadsheet? In this article, I’ll look at various methods and share a few tips for when things go wrong. SQL is the most widely used method of extracting data from a database.
