Variable with current date ?

Hi Everyone,

I am trying to create a variable with the current date and then insert it into a mysql database. Here is what I have so far.

$DatePostedOn= date("F j, Y, g:i a");

when I insert the variable into the table  it shows " 0000-00-00 00:00:00    "

What am I doing wrong ? Please help

What kind of MySQL field are you using to store the value? I fusing one of the date type fields then the format has to be very specific.

http://dev.mysql.com/doc/refman/5.1/en/datetime.html

[Moving to MySQL forum]

the format in mysql is not the same as you're using. convert it to

date("Y-m-d H:i:s");

before inserting.

Thanks that works.  Now when I get the results from the mysql query and print it out it show as " 2011-08-26 04:07:23  "  How do I get it to show as 08/26/2011 ?

  Quote

Now when I get the results from the mysql query and print it out it show as " 2011-08-26 04:07:23  "  How do I get it to show as 08/26/2011 ?

echo date("m/d/Y",strtotime('2011-08-26 04:07:23'));

Hi here is how it's being retreived from database "  <?php echo $rsjobs['PostedOnDate'];?>

$rsjobs is the id corresponding to that row of data.  How do I format this to  "08/26/2011 " ?                  "

<?php echo $rsjobs['PostedOnDate'];?>  time show usp as  2011-08-26 04:12:57

I would like to get it to show up as  08/26/2011

Did you try my code? (changing the date to your var?)

echo date("m/d/Y",strtotime($rsjobs['PostedOnDate']));

Hi Thanks this code work.  Thank you very much.