Collections:
PHP MSSQL - Including Date and Time Values in SQL Statements
PHP MSSQL - How To Include Date and Time Values in SQL Statements?
✍: Guest
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 representing current date and time.
<?php $con = mssql_connect('LOCALHOST','sa','FYIcenter'); mssql_select_db('FyiCenterData', $con); $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 (!mssql_query($sql, $con)) { print("SQL statement failed with error:\n"); print(" ".mssql_get_last_message()."\n"); } else { print("1 rows inserted.\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 (!mssql_query($sql, $con)) { print("SQL statement failed with error:\n"); print(" ".mssql_get_last_message()."\n"); } else { print("1 rows inserted.\n"); } mssql_close($con); ?>
If you run this script, you will get something like this:
1 rows inserted. 1 rows inserted.
⇒ PHP MSSQL - Computing Date and Time Differences
⇐ PHP MSSQL - Including Text Values in SQL Statements
⇑ SQL Server FAQs - PHP MSSQL Functions - Managing Tables and Data Rows
2024-02-18, 1279🔥, 0💬
Popular Posts:
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...