oracleÈÕÆÚ¸ñʽÎÊÌâ
select to_char(rq,'yyyy-mm-dd hh24:mi:00') from table1; ´íÎó£ºÈÕÆÚ¸ñʽÎÞ·¨Ê¶±ð£¬ÎÒÏë°ÑÃë¼¶µÄʱ¼äÏÔʾ³É00 Ôõô¸Ä°¡£¬°ïÎÒ¿´¿´
select to_char(trunc(rq,'mi'),'yyyy-mm-dd hh24:mi:ss') from table1; select to_char(rq,'yyyy-mm-dd hh24:mi:ss') from table1; SQL code: SELECT TO_CHAR(rq,'yyyy-mm-dd hh24:mi')||':00' from table1ÒýÓÃ SQL codeSELECT TO_CHAR(rq,'yyyy-mm-dd hh24:mi')||':00'from table1 up select to_char(trunc(sysdate,'mi'),'yyyy-mm-dd hh24:mi:ss') from dual;
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼ ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ² SQL code:
......
with adod_dict do begin close; commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......