Parse date fields from mysql database

[Bart Braem]

I would like to be able to parse date fields from a MySQL database in order
to get the day, year, hour etc. separately. Which library could do that for
me? I can't think that I would have to parse those dates myself, right?

Bart

 

[Gabriele Marrone]

Il giorno 08/nov/06, alle ore 16:25, Bart Braem ha scritto:

I would like to be able to parse date fields from a MySQL database
in order
to get the day, year, hour etc. separately. Which library could do
that for
me? I can't think that I would have to parse those dates myself,
right?

Just use Date#day, Date#year, Date#hour and so on.

 

[khaines]

I would like to be able to parse date fields from a MySQL database in order
to get the day, year, hour etc. separately. Which library could do that for
me? I can't think that I would have to parse those dates myself, right?

require 'time'

parsed_time = Time.parse(mysql_datetime)


If the mysql field has a value that is outside the range for Ruby's Time
class, you can use DateTime:

require 'date'

parsed_time = DateTime.parse(mysql_datetime)



Kirk Haines

 

[Bart Braem]

parsed_time = DateTime.parse(mysql_datetime)

Combined with the methods from Gabriele this works perfectly, thanks!

Bart

 

[Gabriele Marrone]

Combined with the methods from Gabriele this works perfectly, thanks!

Oops! Sorry, I thought you were using ActiveRecord, so it was already
parsed
Give it a look, of course you can use it outside Rails, if you need
it: http://rubyonrails.org/api/classes/ActiveRecord/Base.html