You'll be better off if you don't do it that way. Compute the day of week from created_at in your scala code (personally I prefer joda time for this sort of thing), instead of having the database do it for you.
Use the database to store and retrieve data, not to perform calculations. -harryh On Nov 9, 1:44 am, "Neil.Lv" <anim...@gmail.com> wrote: > Hi all, > > There is some example code: > ### > SELECT id, name, sex, created_at, DAYOFWEEK(created_at,) as week, > (CURRENT_DATE) as t > FROM users > WHERE created_at > (CURRENT_DATE ) AND created_at < (CURRENT_DATE + > interval 2 day) > ORDER BY created_at ASC > ### > > How can i specify the SELECT statement that i don't want all the > columns and i want add the column as week > in the example code ? > > Any help would be much appreciated! > > Cheers, > Neil --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Lift" group. To post to this group, send email to liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~----------~----~----~----~------~----~------~--~---