急!!informix中如何得到某datetime字段的月份?

[RevivalSky]

我知道在oracle中可以这样写:
select * from table_name where to_char(mydate,'mm')='08'

类似这样的效果在informix中要如何写?

希望哪位大家帮忙!

[wenlq]

select * from tab where extend(d1,month to month ) ='08';

select * from tab where substr(d1,6,2) ='08';

[RevivalSky]

顶一支阿

如果我要做这样的转换呢?

select * from tab where
to_char(to_date(strdate,'yyyy-mm-dd hh24:mi:ss'),'mm')='08'


谁能告诉我?

[Azz1]

select * from tab where month(d1) =8;