On Sat, Mar 13, 2021 at 4:17 AM abhijit <[email protected]> wrote: > Hi Jeremy, > > I was wondering if it is possible to use SQLite Date functions > <https://www.sqlite.org/lang_datefunc.html> to get day of week > from a date column where the values are in julian. > > One of the many things I tried - > > *DB[:table].select(Sequel.function(:date, '%w', :mtime).as(:dayofweek))* > > Here, :mtime is the date column with values as julian. > > Abhijit,
I'm sure it is possible. I'm guessing you should use :strftime instead of :date in your code. Thanks, Jeremy -- 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/CADGZSSefC53QZeJgRoskQ-DJJaYwsVUwiz7d1%3D8a6KE1x2A4Dg%40mail.gmail.com.
