select ick_ydqkb.id
from ick_ydqkb
where ick_ydqkb.czsj = to_date('29-Mar-2003 02:03:04','dd-mon-yyyy hh24:mi:ss');报错说“无效的月份”
------------------------------------------------------------------
select ick_ydqkb.id
from ick_ydqkb
where ick_ydqkb.czsj = to_date('29-Mar-2003 02:03:04','dd-mmm-yyyy hh24:mi:ss');报错说“日期格式无法识别”
----------------------------------------------------------------大家一定要帮帮我!
from ick_ydqkb
where ick_ydqkb.czsj = to_date('29-Mar-2003 02:03:04','dd-mon-yyyy hh24:mi:ss');报错说“无效的月份”
------------------------------------------------------------------
select ick_ydqkb.id
from ick_ydqkb
where ick_ydqkb.czsj = to_date('29-Mar-2003 02:03:04','dd-mmm-yyyy hh24:mi:ss');报错说“日期格式无法识别”
----------------------------------------------------------------大家一定要帮帮我!
from ick_ydqkb
where truncate(ick_ydqkb.czsj) = to_date('29-Mar-2003','DD-MON-YYYY')
select * from table where to_char(date_field,'yyyymmdd')='20020101'
返回截尾到(truncate,这正好和舍入round相对应)y位小数的x值。y缺省设置为o,
这会将x截尾为个整数值。如果y是负数,那么就结尾到小数点左边