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.
12 sty 2020 · It appears that for a DATE or DATETIME field, an empty value cannot be inserted. I got around this by first checking for an empty value (mydate = "") and if it was empty setting mydate = "NULL" before insert.
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.
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.
Date Function DAY() The date function DAY accepts a date, datetime, or valid date string and returns the Day part as an integer value. Syntax: DAY(date)
30 maj 2019 · Solution. In the steps below, I will show one option for 'Filling the Date Gap'. First a Date table is needed to cover your date range. Next, query the Date table with a LEFT JOIN to the source table. Often you will find that you do not have a Date Table.
30 sty 2024 · Problem: Let’s use FORMAT() to get the date from the registered_at values from our table and show it in the day/month/year format. Solution: SELECT user_id, registered_at, FORMAT(registered_at, 'dd/MM/yyyy') AS registered_formatted FROM user_registration;
