date conversion / extraction issue between mssql > php > mysql

Question

This is my code and the output is right after that...

$PDate = $row['PDate'];  
//row is tapping into ms-sql date field. 
//and the ms-sql data field has a value like this for the PDate; 
//07/12/2001
$PDate = $PDate->date;
echo "<h1>[", $PDate , "]</h1>";
echo "<h1>[", var_dump($row['PDate']) , "]</h1>";
echo "<h1>[", serialize($row['PDate']) , "]</h1><hr>";

the output is as follows. And my question is embedded in the output.

[]      ??? WHY IS THIS BLANK? WHY IS THIS NOT 2001-12-07 00:00:00? 

[object(DateTime)#3 (3) { ["date"]=> string(19) "2001-12-07 00:00:00" ["timezone_type"]=> int(3) ["timezone"]=> string(19) "America/Los_Angeles" } ]

[O:8:"DateTime":3:{s:4:"date";s:19:"2001-12-07 00:00:00";s:13:"timezone_type";i:3;s:8:"timezone";s:19:"America/Los_Angeles";}]

Kevin Nielsen · Accepted Answer · 2012-05-02 22:03:45Z

1

The results of var_dump indicate that you're working with a DateTime object. If you want the date in a format that it can be transmitted to output or another database, you'd probably want to try working with $PDate (or $row['PDate']) as a DateTime object.

For instance:

echo $PDate->format("Y-m-d")."\n";

answered May 2, 2012 at 22:03

Kevin Nielsen

4,43323 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marcus Recck · Accepted Answer · 2012-05-02 21:05:21Z

0

$PDate stores the result from the table. So why do you redefine the variable to a variable in an object that doesn't exist. Have you tried just using $row['date'] instead of assigning it to $PDate?

answered May 2, 2012 at 21:05

Marcus Recck

5,0432 gold badges19 silver badges27 bronze badges

1 Comment

Average Joe Over a year ago

If I do that I get this at the time insert; Catchable fatal error: Object of class DateTime could not be converted to string in sql.php on line 379

Collectives™ on Stack Overflow

date conversion / extraction issue between mssql > php > mysql

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related