Re: Day of the week

On 12/10/2016 6:17 AM, Daniele wrote:
> Hi to all,
> i'm new in this group and new with sql.
>
> I'm reading a firebird (2.5) database, in a table there is a field DATE
> where is stored the record date and time.
> In my sql request i need to select all records saved on each day of week
> = 1 (monday)
>
> I tried with DAYOFWEEK but it's a unknow function.
>
> My query, which does not work in FlameRobin and DBeaver (Error: Function
> unknow DAYOFWEEK).
>
> Selcet * from Table1 where DayOfWeek(Table1."DATE")=1
>
> Can you help me?
>
> Thank's for all
>
> Daniele

If you post in the appropriate place, you'll get a good answer. This newsgroup is for the MySQL database (hence the "mysql" in its name). You won't generally get good answers for firebird here (as the well-known troll TNP just proved).

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
jstucklex_at_attglobal.net
==================