something strange with sqlite ?

[Joe Guerra]

I have an active record query (for my categories) that check for the date ( .where( 'enddate > ?', todaydate )).

Today's date get's wrapped in quotes, and it fails to produce any records, but it's perfectly fine in postgres.

[Rob Zolkos]

I think you will need to wrap todaydate in strftime for sqlite.   Away from computer to check but google ‘date arithmetic sqlite’

On Tue, 18 Sep 2018 at 6:20 am, Joe Guerra <JGu...@jginfosys.com> wrote:

I have an active record query (for my categories) that check for the date ( .where( 'enddate > ?', todaydate )).

Today's date get's wrapped in quotes, and it fails to produce any records, but it's perfectly fine in postgres.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-ta...@googlegroups.com.
To post to this group, send email to rubyonra...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/394a0f57-7d77-4d73-82ce-fd9730bc90b3%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Joe Guerra]

Thanks, I'll try that.

Hopefully it works for postgres and sqlite.

To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAJ6MPzJR9hQOO-ECQ8rd2DrC0JOUmX1JzymD%3Df%3DgU0TkJA94qg%40mail.gmail.com.

[Rob Zolkos]

doubtful.  They are very different.  Any reason you can't stick with one of them?

To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAOFgAMmVVh5jtGQU3jwHDhb1f74OJp6m88FYaV5S0V%2BJ%2BKRRkQ%40mail.gmail.com.

[Hassan Schroeder]

What exactly is "todaydate"? What's the column definition of "enddate"?

And are you sure you have identical records in both DBs you're testing
this with?

--
Hassan Schroeder ------------------------ hassan.s...@gmail.com
twitter: @hassan
Consulting Availability : Silicon Valley or remote

[Joe Guerra]

Hi, I defined time like this --->

  require 'time'

    todaydate = Time.new

    todaydate = todaydate.year.to_s + "-" + todaydate.month.to_s + "-" + todaydate.day.to_s

and the column for enddate is a date type.   It had worked previously, I just updated the dates in a populate rake file and stopped working (on the development env (sqlite)).

Thanks,

Joe

[Hassan Schroeder]

On Tue, Sep 18, 2018 at 5:59 AM, Joe Guerra <JGu...@jginfosys.com> wrote:

> todaydate = Time.new
>
> todaydate = todaydate.year.to_s + "-" + todaydate.month.to_s + "-" +
> todaydate.day.to_s
>
> and the column for enddate is a date type.

Aside from the potential problem of redefining the same variable,
I'd avoid trying to compare a DB `date` with a String, but in this case --

Sqlite3 doesn't have a `date` type so you might want to spend a few
minutes here: https://www.sqlite.org/datatype3.html

HTH!