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.
