Syntax in MySQL for date in Ruby on Rails

Question

I used SQLite3 as my database, but now I changed it to MySQL. There is one line in my code which is failing now. What is the syntax for MySQL?

<% year = os.ot_daily_date.strftime("%Y")%>

This line is showing the following error:

ActionView::Template::Error (Mysql2::Error: FUNCTION hrms_development.strftime
does not exist: SELECT `overtime_daily_records`.* FROM `overtime_daily_records`
GROUP BY strftime('%Y',ot_daily_date)):

@anu jainThere is no strftime function in MySQL. Use DATE_FORMAT instead. — Dnyanarth lonkar
– Dnyanarth lonkar, Commented Apr 5, 2017 at 9:25

hoangdd · Accepted Answer · 2017-04-05 09:24:07Z

0

You can try:

<% year = os.ot_daily_date.year %>

Explain: os.ot_daily_date will return a Date value if ot_daily_date have date data type in your Mysql database.

Hope this helps.

answered Apr 5, 2017 at 9:24

hoangdd

5092 silver badges14 bronze badges

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

1 Comment

hoangdd Over a year ago

can you show me the result of os.ot_daily_date.class?

Dnyanarth lonkar · Accepted Answer · 2017-04-05 10:04:00Z

0

Try this:

<% year = os.ot_daily_date.to_date.year %>

edited Apr 5, 2017 at 10:04

answered Apr 5, 2017 at 9:56

Dnyanarth lonkar

8697 silver badges13 bronze badges

2 Comments

Sergio Tulentsev Over a year ago

1) the supplied error message does not support your hypothesis. 2) rails does not turn everything into strings first time it sees an object. So os.ot_daily_date (prior to calling strftime on it) would be in no way affected by rails view rendering.

Sergio Tulentsev Over a year ago

Now the answer lacks explanation. What do you think the problem is, and why this code should help?

Collectives™ on Stack Overflow

Syntax in MySQL for date in Ruby on Rails

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related