Re: Day of the week
From: Daniele <io_at_io.it>
Date: Sat, 10 Dec 2016 12:45:07 +0100
Message-ID: <o2gps9$1let$1_at_gioia.aioe.org>
Date: Sat, 10 Dec 2016 12:45:07 +0100
Message-ID: <o2gps9$1let$1_at_gioia.aioe.org>
Hi,
[Quoted] >> selcet * from Table1 where DayOfWeek(Table1."DATE")=1
> select * from Table1 where DayOfWeek(Table1.DATE)=1 ;
> perhaps?
No, after searching, reading and understanding i got the soluction !! here the correct query for Firbird
Selcet * Table1."DATE" From Table1 Where EXTRACT(WEEKDAY From Table1."DATE)=1 and Table1.Year=2016 and Table1.Month=12
(To extract all monday for year 2016 and December month ; Result 5)
Thank's for helping me !
Good WeekEnd
Daniele
PS: Here the link
http://mujweb.cz/iprenosil/interbase/ip_ib_code_timestamp.htm
Received on Sat Dec 10 2016 - 12:45:07 CET