Yahoo Poland Wyszukiwanie w Internecie

Search results

1. stackoverflow.com › questions › 15554369Show empty string when date field is 1/1/1900 - Stack Overflow

   stackoverflow.com › questions › 15554369

   21 mar 2013 · In this case you can't just set a DATETIME to an empty string. Try it: 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

2. www.encodedna.com › 2014 › 03Show Date and Time as Blank instead of 1900-01-01 - SQL Server

   www.encodedna.com › 2014 › 03

   • Zapisane w pamięci cache

   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. Date and Time are not character values and therefore, you must handle it carefully. ← Previous

3. dba.stackexchange.com › questions › 89942SQL Server Isnull Returning 1900-01-01 when field is null

   dba.stackexchange.com › questions › 89942

   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.

4. www.codelabs365.com › sql-cookbook › sql-serverT-SQL Format DATE or DATETIME as String. 44 Common ... -...

   www.codelabs365.com › sql-cookbook › sql-server

   • Zapisane w pamięci cache

   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

5. www.mssqltips.com › sqlservertip › 2655Format SQL Server Dates with FORMAT Function

   www.mssqltips.com › sqlservertip › 2655

   • Zapisane w pamięci cache

   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

6. www.w3schools.com › sql › sql_datesDate Functions in SQL Server and MySQL - W3Schools

   www.w3schools.com › sql › sql_dates

   • Zapisane w pamięci cache

   DATETIME - format: YYYY-MM-DD HH:MI:SS. TIMESTAMP - format: YYYY-MM-DD HH:MI:SS. YEAR - format YYYY or YY. 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.

7. www.freecodecamp.org › news › sql-convert-the-date-to-string-or-datetime-function-2SQL CONVERT – The DATE to String or DATETIME Function

   www.freecodecamp.org › news › sql-convert-the-date-to-string-or-datetime-function-2

   • Zapisane w pamięci cache

   10 sty 2023 · In this article, I want to show you how to convert a date and datetime to a string in SQL with the CONVERT() and STR_TO_DATE() functions. What We'll Cover. How to Convert Date to String with the CONVERT() Function; How to Convert Date to String with the STR_TO_DATE() Function; How to use the DATE_FORMAT() to Change the Time Format; Conclusion