Hi there. I have a table with dates from over the last 11 years. I want
to find all "March 5th".
I'm assuming the proper way is to call the EXTRACT function:
puts TW.where{Sequel.function(extract(:day, :month) == 3)}.sql # =>
SELECT * FROM "points" WHERE false()
That is "extract day from month", and I've also reversed those two symbols,
with the same result of 'false()'.
It is a date function. I would like to manipulate both month and day so I
can iterate through the year's days.
The field in question is called 'day', which is a Date field 'YYYY-MM-DD'.
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/e880ec05-d904-473d-9e66-6ab3b281fcef%40googlegroups.com.
