Magento date from string

Question

I've exported reviews from mysql db in a csv format, and I've included created_at field. Now, when I open CSV file, date is in following format: 2014-02-04 13:31:43. So, I now want to import those reviews into different website, and everything works except for created_at date, for which I'm using following code:

// $_row['created_at'] = '2014-02-04 13:31:43';
// $_review is the object I created with
// $_review = Mage::getModel('review/review');
$_created_at = Mage::helper('core')->formatDate($_row['created_at'], 'medium', false);
$_review->setCreatedAt($_created_at);

but that doesn't set created_at properly. What's the correct way of achieving this?

does $_created_at has value?

NID
– NID

2017-02-21 10:33:26 +00:00
Commented Feb 21, 2017 at 10:33 — NID
– NID, Commented Feb 21, 2017 at 10:33
Yes, string(12) "4. feb. 2014".

errorous
– errorous

2017-02-21 10:45:24 +00:00
Commented Feb 21, 2017 at 10:45 — errorous
– errorous, Commented Feb 21, 2017 at 10:45

Vinay · Accepted Answer · 2017-02-21 10:34:17Z

1

Try this ...

$createdtime = new Zend_Date(strtotime($_row['created_at']));
$_created_at = Mage::getModel('core/date')->date('M d, Y', $createdtime);
$_review->setCreatedAt($_created_at);

answered Feb 21, 2017 at 10:34

Vinay

3341 silver badge13 bronze badges

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

1 Comment

errorous Over a year ago

Nope. Still creates a date as if I used time();

Collectives™ on Stack Overflow

Magento date from string

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related