Parse date fields from mysql database

Ruby
1

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

2

Il giorno 08/nov/06, alle ore 16:25, Bart B. 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.

3

On Thu, 9 Nov 2006, Bart B. wrote:

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 H.

4

[email protected] wrote:

parsed_time = DateTime.parse(mysql_datetime)

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

Bart

5

On 08/nov/06, at 20:30, Bart B. wrote:

[email protected] wrote:

parsed_time = DateTime.parse(mysql_datetime)

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

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