Subject AW: [firebird-support] Array datatype?
Author Check_Mail

Hello Alan,

 

Im using now the extract function an there is 0 = Sunday, 1 = Monday I think.

 

 

Von: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
Gesendet: Donnerstag, 29. August 2019 09:23
An: firebird-support@yahoogroups.com
Betreff: RE: [firebird-support] Array datatype?

 

 

Hello Kjell,

 

then I have to do the mapping between Monday = 1, Tuesday = 2, Sunday = 0. But I can only select the value with an execute statement.

 

I will test it, thank you. 😊

 

WHEN F_DAYOFWEEK(J.COMMDATE)=1 /* Sunday */

??

 

Alan McDonald