Saving Date/Time to mysql database ?

[yusufhermanto]

can anybody tell me, how to save Date or time to the database.

i always found error for this data.

 

thanks,

[taith]

just in your database, make either a text field, and fill it with a time(), or make a timestamp field

[yusufhermanto]

just in your database, make either a text field, and fill it with a time(), or make a timestamp field

 

this my code:

mysql_query("delete from pr where no_pr='".$nopesanan."'");

                                        $s="insert into pr

(no_pr,tgl_pr,kd_cust)

values('".$nopesanan."',

'".Time()."','".$cbocust."')";

    mysql_query($s) or die(mysql_error());

 

 

this code can not save date for tgl_pr field

[taith]

what type of field is tgl_pr?

$time=time();

mysql_query("insert into pr (no_pr,tgl_pr,kd_cust) values('$nopesanan', '$time','$cbocust')") or die(mysql_error());

 

[yusufhermanto]

what type of field is tgl_pr?

$time=time();

mysql_query("insert into pr (no_pr,tgl_pr,kd_cust) values('$nopesanan', '$time','$cbocust')") or die(mysql_error());

 

 

tgl_pr type is dateTime