Ruby convert Mysql timestamp to Mysql datetime

Question

I am trying to import data from a DB to another. The source DB has TIMESTAMP (mysql) the destination has DATETIME (mysql). I am trying something like that:

start_at = DateTime.at(row['QA_CONF_START_STAMP']) #start_at

But it is not working

tadman · Accepted Answer · 2009-10-22 19:20:39Z

1

I'm not sure if conversion is expressly required in this case, as the two values should be equivalent.

Since you're not retrieving the original data using a model, it's coming through as a raw string. The easiest way to interpret that is:

DateTime.parse(row['QA_CONF_START_STAMP'])

answered Oct 22, 2009 at 19:20

tadman

212k23 gold badges237 silver badges266 bronze badges

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

Collectives™ on Stack Overflow

Ruby convert Mysql timestamp to Mysql datetime

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related