Toad World® Forums

extract(month from sysdate) gives no result


#1

Hi!

Run following statement in beta:

select extract(month from sysdate) from dual;

You get no result there.
This works fine in version 6.1.

regards


#2

Nice find!
It also happens with extract(year … and extract(day from a data column, even when we have select more columns

For instance

select date_change, extract(day from data_change) from table_a;

(where date_change is of date datatype)
doesn’t show results , but

select data_change from table_a;

show results

Regards
Filipe


#3

Hi guys,

Thanks for pointing this out. We will have it fixed ASAP.

Cheers,
Gwen


#4

Works again in newest beta 6.2.0.1476!


#5

Thanks for the update Torsten.