Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Quote Date and Time Values in SQL Statements
How To Quote Date and Time Values in SQL Statements? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts
✍: 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.
2007-05-11, 5295👍, 0💬
Popular Posts:
What exactly happens when ASPX page is requested from Browser? Note: - Here the interviewer is expec...
How was XML handled during COM times? During COM it was done by using MSXML 4.0. So old languages li...
How can we implement singleton pattern in .NET? Singleton pattern mainly focuses on having one and o...
What is PMP(project management plan)? The project management plan is a document that describes the p...
How To Check the Oracle TNS Settings? - Oracle DBA FAQ - ODBC Drivers, DSN Configuration and ASP Con...