Time & date

[BBKing]

hi . how to add date in mysql database without unix timestamp (1235686680) ?
e.g : 01-01-2009-10-25 or 01/01/2009/10-25 . and mysql type ?? text ? varchar ? date ? thanks . sorry im unprofessional .

[sneakyimp]

You should probably use either a date or datetime field in your MySQL database. Read the MySQL docs on these data types to learn more. To get a time and date from PHP into MySQL and back is always going to involve a conversion of some kind. You can either do it in MySQL like this or you can create a datetime value in PHP using the [man]date[/man] function.

<?php
$now = time();
$datetime = date('Y-m-d H:i:s', $now);
echo $datetime . "\n";
?>

[dagon]

if the date your inserting is "now" theres two more options to the abeove

mysql's "NOW()"

insert into foo date_time values(NOW());

or set a timestamps field "default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP""

[BBKing]

i write this code :

<?php
$date	= explode('-', gmdate('m-d-Y-H-i', CURRENT_TIME + $Info->option['timezone']*3600));
		$month	= intval($date[0]); // for update with option form 
		$day	= intval($date[1]);
		$year	= intval($date[2]);
		$time	= $date[3] .":". $date[4]; ?>

so

<?php
$this->data["ptime"]	= gmmktime($hour, $minute, 0, $this->data["month"], $this->data["day"], $this->data["year"]) - $Info->option['timezone']*3600; ?>

and INSERT $this->data["ptime"] in table . but with this save date & time with unix timestamp .

[Weedpacket]

Was there a question in there somewhere?

[BBKing]

Weedpacket;10905119 wrote:

Was there a question in there somewhere?

how to add date without timestamp method in mysql table ??
with my code add date & time with 1235894163 . Unix timestamp ( php4 1970 - 2038 ) ( php5 1901 - 2038 ) supported .

now how to add date & time with 01-01-2009 10:10 method ???

i add with this code :

sneakyimp

<?php
$now = time();
$datetime = date('Y-m-d H:i:s', $now);
$this->data["date"] =  $datetime;
?>

insert $this->data["date"] in mysql table .

ERROR : add -12600 in table .

[sneakyimp]

I have no idea what you are asking.

[Weedpacket]

BBKing wrote:

how to add date without timestamp method in mysql table ??

What's wrong with the answers you have already been given?