how to

jannoy

hello guys
how can i save data in DATETIME fields

thanks

Weedpacket

Are we talking databases here? Which database server? MySQL? I'm sure MySQL has some information on the subject in its documentation. No doubt all the other DBMSs do, as well.

TheDefender

Are you asking how to write your INSERT query? Or how to write a form to collect the info? Or how to make the field a DATETIME format? Or how to format the input to store it?

Give more details on precisely what you are wanting to know how to do...

jannoy

well thank you for the specific details, im asking about DATETIME format how to create a DATETIME Format since in my table there is a field DATETIME

TheDefender

// Takes current date and time, and makes it into the MySQL DATETIME column type format.
$now = date("Y-m-d H:i:s");
echo $now;

You can see this echos the current date and time in YYYY-MM-DD HH:MM:SS format (DATETIME). Once you have the variable, you just insert away. (I recommend you make it an INT type field, and store the datetime in UNIX TIMESTAMP format, which is like so:

// Takes current date and time, and makes it into a UNIX TIMESTAMP format.
$now = time();
echo $now;

It just makes it tons easier to manipulate it later...