Variable with current date ?

[jobs1109]

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

[Psycho]

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]

[WebStyles]

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

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

 

before inserting.

[jobs1109]

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 ?

[WebStyles]

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'));

[jobs1109]

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 " ?                  "

[jobs1109]

<?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

[WebStyles]

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

 

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

[jobs1109]

Hi Thanks this code work.  Thank you very much.