Yahoo Poland Wyszukiwanie w Internecie

Search results

1. stackoverflow.com › questions › 26282007sql - Convert NULL datetime to Blank - Stack Overflow

   stackoverflow.com › questions › 26282007

   24 paź 2014 · I would like to convert a datetime field to varchar so I can show a blank or a message when the date is NULL. This is what I have so far: select isnull(us.Date,0) as USDate, isnull(au.Date,0) as AUDate from ustable us left join autable au on us.column=au.column

2. www.sqlshack.com › working-with-sql-null-valuesWorking with SQL NULL values - SQL Shack

   www.sqlshack.com › working-with-sql-null-values

   • Zapisane w pamięci cache

   19 maj 2021 · Handling SQL NULL values with Functions. As we stated earlier, SQL Server offers some functions that help to handle NULL values. ISNULL (): The ISNULL () function takes two parameters and it enables us to replace NULL values with a specified value. 1. ISNULL (expression,replacement)

3. dba.stackexchange.com › questions › 132986mysql - How to replace an empty date value? - Database...

   dba.stackexchange.com › questions › 132986

   22 mar 2016 · I am trying to replace many null date values in a single column using this query: UPDATE animal SET. BirthDate = '1900-01-01 06:00:00 AM' . WHERE BirthDate = ''' MySQL shows this error:

4. www.php.net › manual › enPHP: mysqli::query - Manual

   www.php.net › manual › en

   • Zapisane w pamięci cache

   For successful queries which produce a result set, such as SELECT, SHOW, DESCRIBE or EXPLAIN, mysqli_query() will return a mysqli_result object. For other successful queries, mysqli_query() will return true .

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

   www.w3schools.com › sql › sql_dates

   • Zapisane w pamięci cache

   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. TIMESTAMP - format: a unique number.

6. www.php.net › manual › enPHP: mysql_query - Manual

   www.php.net › manual › en

   • Zapisane w pamięci cache

   mysql_query (string $query, resource $link_identifier = NULL): mixed mysql_query() sends a unique query (multiple queries are not supported) to the currently active database on the server that's associated with the specified link_identifier .

7. stackoverflow.com › questions › 20647842How do I select a date field when NULL is present?

   stackoverflow.com › questions › 20647842

   18 gru 2013 · select if(isnull(date_field) or date_field = '1900-01-01 00:00:00', null, date_field) from table_name;