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, 1271👍, 0💬
Popular Posts:
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...