Collections:
Quoting Date and Time Values in MySQL
How To Quote Date and Time Values in SQL Statements in MySQL?
✍: FYIcenter.com
If you want to provide date and time values in a SQL statement, you should write them in the format of "yyyy-mm-dd hh:mm:ss", and quoted with single quotes ('). The tutorial exercise below shows you two INSERT statements. The first one uses a hard-code date value. The second one uses the date() function to return a date value.
<?php include "mysql_connection.php"; $notes = "Added long time ago!"; $time = "1999-01-01 01:02:03"; $sql = "INSERT INTO fyi_links (id, url, notes, time)" . " VALUES (" . " 301, 'netscape.com', '".$notes."', '".$time."')"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); } else { print("SQL statement failed.\n"); } $notes = "Added today!"; $time = date("Y-m-d H:i:s"); $sql = "INSERT INTO fyi_links (id, url, notes, time)" . " VALUES (" . " 302, 'myspace.com', '".$notes."', '".$time."')"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); } else { print("SQL statement failed.\n"); } mysql_close($con); ?>
If you run this script, you will get something like this:
1 rows inserted. 1 rows inserted.
⇒ Dispaly Part Time in Days, Hours and Minutes in MySQL
⇐ Quoting Text Values in MySQL
2017-06-23, 1586🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...