Subject RE: [firebird-support] Date Function
Author Norbert Saint Georges
Post date 2015-04-02T07:09:42Z

Hei,

 

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 : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Envoyé : jeudi 2 avril 2015 09:55
À : firebird-support@yahoogroups.com
Objet : [firebird-support] Date Function

 

 

Hello,

 

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.

 

Thanks

 

Best regards

 

Olaf