February 3rd, 2011, 04:09 AM
Day number for year
I use extract day command from firebird but it return MONTH of day numbe 1-30.
I need day number for year 1-365.
for example 1 February should be 32. day for year.
if i use extract DAY it return 1
is there any command for this in firebird?
February 3rd, 2011, 04:24 AM
Please show us exactly how the SQL looks like that you are using
February 3rd, 2011, 05:04 AM
sum((VWKASA_TUTAR * VWKASA_carpan)),
sum(VWKASA_TLTUTAR * VWKASA_carpan),
extract(DAY from VWKASA_KAYITTARIHI)
February 3rd, 2011, 05:25 AM
According to the manual:
you are looking for YEARDAY
February 3rd, 2011, 05:33 AM