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 SQL Query. SELECT DateEdited = . CASE WHEN DateEdited = '1900-01-01 00:00:00.000' THEN '' . ELSE CONVERT (VARCHAR(10), DateEdited, 103) . END . FROM Product_List. 📋. The query above will actually convert the date to a string value. The CONVERT () function will translate the value in a string format.
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.
SQL Server comes with the following data types for storing a date or a date/time value in the database: DATE - format YYYY-MM-DD. DATETIME - format: YYYY-MM-DD HH:MI:SS. SMALLDATETIME - format: YYYY-MM-DD HH:MI:SS. TIMESTAMP - format: a unique number.
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
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
6 gru 2015 · The column [PAYOFF DATE] has some blank values and some values in mm/dd/yy format. I have to replace '/' with '-' and return the date as yyyy-mm-dd. The below query is doing it.
