以下是我要解决的实际问题.
我要从ORACLE中的一张表上读出数据.这张表有一列是Date类型.我需要将时间处在指定范围内的数据读出来.
System.Data.OracleClient.OracleDataAdapter ora_adp =
new System.Data.OracleClient.OracleAdapter("select * from main where time ... ...",oracleConnection1);
请大家指点.
我要从ORACLE中的一张表上读出数据.这张表有一列是Date类型.我需要将时间处在指定范围内的数据读出来.
System.Data.OracleClient.OracleDataAdapter ora_adp =
new System.Data.OracleClient.OracleAdapter("select * from main where time ... ...",oracleConnection1);
请大家指点.
to_char (sysdate, 'Month DD, YYYY'); would return 'July 09, 2003'
to_char (sysdate, 'FMMonth DD, YYYY'); would return 'July 9, 2003'
to_char (sysdate, 'MON DDth, YYYY'); would return 'JUL 09TH, 2003'
to_char (sysdate, 'FMMON DDth, YYYY'); would return 'JUL 9TH, 2003'
to_char (sysdate, 'FMMon ddth, YYYY'); would return 'Jul 9th, 2003'
to_date ('070903', 'MMDDYY'); would return a date value of July 9, 2003.
to_date ('20020315', 'yyyymmdd'); would return a date value of Mar 15, 2002.
是这样吗?怎么查出来的结果不对呢?