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 · SQL Server DATE and DATETIME data types store date and time values in a table. However, managing these values can become difficult sometimes, especially if the value saved is 1900-01-01. Moreover, we cannot show or display these figures anywhere, since it can be misleading.
28 maj 2024 · We'll look at several examples of using the SQL CONVERT function to convert and optionally format date, datetime, string, and integer data types. Here are some reasons you might use the CONVERT function: Display dates in a different format; Display numbers in a different format; Convert integers or dates to strings to concatenate with text data
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 maj 2012 · Use the FORMAT function to format the date and time data types from a date column (date, datetime, datetime2, smalldatetime, datetimeoffset, etc. data type) in a table or a variable such as GETDATE() To get DD/MM/YYYY use SELECT FORMAT (getdate(), 'dd/MM/yyyy ') as date
In this post, we will demonstrate 44 common examples of formatting DATE or DATETIME values to string using the built-in FORMAT function available in SQL Server 2012 and later versions. You can use this Fiddle to follow along and practice formatting DATETIME to String.
The following script shows the application of the MMDDYYYY_TO_SQL_DATE user-defined function in the Staging database to transform a column of ASSIGN DATE values from the #MSQLTips_MMDDYYYY_Dates temporary table in mmddyyyy format to SQL Server dates.
