Hi, I have a unix timestamp in an xml feed that I want to convert to a mysql datetime before I put it into my database. Any hints? Charlie
on 2007-06-07 20:09
on 2007-06-07 20:12
Let me ask this another way. Is it possible to store it in mysql as a unix timestamp, then format it the way I want it, if I ever want to display it? When I try to put it in my mysql database as a unix timestamp, it's rejected (the column format is datetime). Charlie On Jun 7, 9:09 am, "firstname.lastname@example.org"
on 2007-06-07 20:57
some_time = Time.now some_time.to_s(:db) On Jun 7, 12:12 pm, "email@example.com"
on 2007-06-07 21:08
One other thing XML has it's own standard for time. ./script/console >> some_time = Time.now => Thu Jun 07 12:58:50 -0400 2007 >> some_time.to_s(:db) => "2007-06-07 12:58:50" >> some_time.xmlschema => "2007-06-07T13:02:53-04:00" Also take a look at Time::parse class method for converting string representations of time into ruby Time objects.
on 2007-06-07 21:54
I can't see how to use Time::parse to turn a unix epoch timestamp (like 1181083337) into a date time format I can put into the database. I see, though, from the Class:Time document page, that Time.at can do this. But I get an error when I try: While I'm importing xml in my controller, and before I put the time into the database, I try to convert it from unix epoch time into a datetime with time.at, like this: publish_date_unix = news_publish_dates[idx] newslistings_publish_date = Time.at(publish_date_unix) And I get this error: can't convert String into time Charlie
on 2007-06-07 21:56
One more thing -- when I say, at the console puts Time.at(1181083337) it works -- I get Tue Jun 05 15:42:17 -0700 2007 Charlie On Jun 7, 10:53 am, "firstname.lastname@example.org"
on 2007-06-07 22:02
On Jun 7, 2007, at 1:55 PM, email@example.com wrote: >> Time.at(publish_date_unix) perhaps: Time.at(publish_date_unix.to_i) -Rob Rob B. http://agileconsultingllc.com firstname.lastname@example.org
on 2007-06-07 22:14
Got it, thank you. On Jun 7, 11:01 am, Rob B. <email@example.com>