How To Insert Current Date And Time Into Mysql

RegisterLogin
Webune Forums » MYSQL » How To Insert Current Date And Time Into Mysql
How To Insert Current Date And Time Into Mysql
Post Description: Inserting The Current Date And Time Into Mysql Database Table Is Easy If You Do This Query On Your Mysql Database
Tags: How, To, Insert, Current, Date, And, Time, Into, Mysql
This Post Was Posted On Oct 29, 2009 By Webune Tutorials #2665
How To Insert Current Date And Time Into Mysql by Webune Tutorials
Hello

Welcome to Webune Support Forums. We provide MySQL database hosting for Dynamic Websites. if you are not happy with your current hosting provider, we recommend you switch to Webune Today.

Today we are going to show you how easy it is to inster the current time and date into your MySQL queries using PHP. for example, you can use this simple query to do what you are looking for.. here it is:

PHP CODE:
$sql = "INSERT INTO log(time) values (now())'"


another way you can do the same query is by doing it like this:

PHP CODE:
$sql = "INSERT INTO log SET time = now()"


does this help?
©2012 Webune Forums - Wed Dec 12, 2012 4:49 pm
Powered by: Webune Forums V3