How to convert user input into MySQL date format?

Question

In my Ruby on Rails 4 app I need to convert user entered dates like...

25.07.2014
25/07/2014

...possibly even...

25-07-2014

...into a the default Date format that can be stored in MySQL database.

2014-07-25

How can this be done?

Thanks for any help.

ex0ns · Accepted Answer · 2014-07-25 13:33:03Z

1

Use strftime: http://www.ruby-doc.org/core-2.1.2/Time.html#method-i-strftime

date = Time.parse(params[:date])
date.strftime("'%Y-%m-%d'");

answered Jul 25, 2014 at 13:33

ex0ns

1,1268 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

falsetru · Accepted Answer · 2014-07-25 13:31:15Z

1

Using String#sub or String#sub!, gsub or gsub!:

'25.07.2014'.sub(/(\d{2})\D(\d{2})\D(\d{4})/, '\3-\2-\1')
# => "2014-07-25"
'25/07/2014'.sub(/(\d{2})\D(\d{2})\D(\d{4})/, '\3-\2-\1')
# => "2014-07-25"

answered Jul 25, 2014 at 13:31

falsetru

371k69 gold badges769 silver badges659 bronze badges

Comments

Grych · Accepted Answer · 2014-07-25 13:34:19Z

1

Use Time.parse, Luke. It covers all your examples.

>> require 'time'
=> true
>> Time.parse '25.07.2014'
=> 2014-07-25 00:00:00 +0200
>> Time.parse '25/07/2014'
=> 2014-07-25 00:00:00 +0200
>> Time.parse '25-07-2014'
=> 2014-07-25 00:00:00 +0200
>> Time.parse '2014-07-25'
=> 2014-07-25 00:00:00 +0200

More in the article Ruby for Admins: Date and Time

answered Jul 25, 2014 at 13:34

Grych

2,90115 silver badges22 bronze badges

Collectives™ on Stack Overflow

How to convert user input into MySQL date format?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related