Oh, to finish up. Time.parse looks to be sufficient for what you are after, too.
>> date = Time.parse('2010-07-20T11:49:19.000Z')
date = Time.parse('2010-07-20T11:49:19.000Z')
=> Tue Jul 20 11:49:19 UTC 2010
>> date.class.name
date.class.name
=> "Time"
>> date.to_s(:db)
date.to_s(:db)
=> "2010-07-20 11:49:19"
IIRC, the ActiveSupport::TimeWithZone class is better at handling
pre-1900 dates than Rails extension of the Time class.
Cheers,
Walter
On Wed, Jul 21, 2010 at 2:36 PM, Walter McGinnis
<[email protected]> wrote:
> Time.zone.parse might be your friend here:
>
>>> date = Time.zone.parse('2010-07-20T11:49:19.000Z')
> date = Time.zone.parse('2010-07-20T11:49:19.000Z')
> => Tue, 20 Jul 2010 11:49:19 UTC +00:00
>>> date.to_s(:db)
> date.to_s(:db)
> => "2010-07-20 11:49:19"
>>> date.class.name
> date.class.name
> => "ActiveSupport::TimeWithZone"
>
> Rails extensions to Time and Date classes can take a bit to work out
> in certain circumstances.
>
> Hope that helps,
> Walter
>
> On Wed, Jul 21, 2010 at 8:31 AM, Steve Root <[email protected]> wrote:
>> Hello everyone,
>>
>> I've been struggling with something that is probably very simple.
>>
>> I need to save an entry from an atom feed that has a datetime string
>> like this:
>> 2010-07-20T11:49:19.000Z
>> which is an XMLSchema date time.
>>
>> I've tried many variations around:
>>
>> glog.elements.each("published") do |element|
>> �[email protected] =
>> Time.xmlschema(element.text).to_s(:db)
>> end
>>
>> If I save that to a regular string I get what looks correct to me:
>> "2010-07-20 11:49:19"
>> but saved in the entrycreated column it outputs as: "Sat Jan 01
>> 11:49:19 UTC 2000"
>>
>> Can anyone help me with the correct code to save this datetime
>> correctly pleased.
>>
>> In case it's relevant, on my dev machine I have sqlite. Eventually it
>> will be on mysql.
>> Thanks for any help,
>> Steve
>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Ruby on Rails: Talk" group.
>> To post to this group, send email to [email protected].
>> To unsubscribe from this group, send email to
>> [email protected].
>> For more options, visit this group at
>> http://groups.google.com/group/rubyonrails-talk?hl=en.
>>
>>
>
--
You received this message because you are subscribed to the Google Groups "Ruby
on Rails: Talk" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.
