Subject RE: [firebird-support] Date Function
Author Norbert Saint Georges



select extract( weekday from cast('now' as date))  from rdb$database


result : 0 - 6



   Norbert Saint Georges


   TetraSys Oy

   Bergantie 69, FI-02540 Kylmälä

   Tel. : +358 (0) 400 27 25 18

   E- mail : nsg@...


De : []
Envoyé : jeudi 2 avril 2015 09:55
À :
Objet : [firebird-support] Date Function





is there an easy way to get all days from a month? I would like to insert all days from a month and not every month has 31 days J


If not, I can create a stored Procedure who checked if the date is possible and returns me if is okay or not.


Then is there a function available to get the weekday of the day without freeadhocudfdll? From Monday to Sunday in terms of 1 to 7 or so.




Best regards