[Resolved] Windows mysql

[artoo]

What is the best way to save a date in mySQL running on a Windows machine. I tried saving a timestamp but all I get are zeros.

Thanks

Artoo

[tsinka]

That shouldn't depend on the OS version ...

what type did you choose for the column in the table and what did the date string/value look like you tried to insert ?

Zero means:

You tried to insert a date value that couldn't be interpreted as a valid date. MySQL automatically inserts 0 in these cases.

Thomas

[artoo]

I'm selecting a date from three text fileds (name d,m,y) and passing those into

checkdate($_POST['m'],$_POST['d'],$_POST['y']) ;

to validate it.

If it is a valid date I then create a timestamp for that date, then try to insert that value into a field of type "timestamp(14)" named 'dateAdded"

$timestamp = mkdate(0,0,0,$_POST['m'],$_POST['d'],$_POST['y]');
$sql = "INSERT INTO movies (title, rating,dateAdded) VALUES ('".$_POST['title']."', '".$_POST['rating']."' ,".$timestamp.")";
$res = mysql_query($sql);

[tsinka]

Hi,

thats the problem ... timestamp(14) stores dates in the form

yyyymmddhhmmss (not unix timestamp)

So to insert the date do

$timestamp = date("YmdHis",mktime(0,0,0,$POST['m'],$POST['d'],$_POST['y]'));

Thomas

[artoo]

Thanks for the info.

What type should that field be if I am wanting to store the unxi timestamp in the datebase?

[tsinka]

Hi,

use int or bigint if you just want to store a unix timestamp.

Thomas