OracleÖм¸¸ö¹ØÓÚÈÕÆÚ·½ÃæµÄSQLʵÀý
¡í1:È¡µÃµ±Ç°ÈÕÆÚÊDZ¾Ôµĵڼ¸ÖÜ
SQL> select to_char(sysdate,'YYYYMMDD W HH24:MI:SS') from
dual;
TO_CHAR(SYSDATE,'YY
-------------------
20030327 4 18:16:09
SQL> select to_char(sysdate,'W') from dual;
T
-
4 ¡í2:È¡µÃµ±Ç°ÈÕÆÚÊÇÒ»¸öÐÇÆÚÖеĵڼ¸Ìì,×¢ÖØÐÇÆÚÈÕÊǵÚÒ»Ìì
SQL> select
sysdate,to_char(sysdate,'D') from dual;
SYSDATE T
--------- -
27-MAR-03 5 ÀàËÆ: select to_char(sysdate,'yyyy') from dual;
--Äê
select to_char(sysdate,'Q' from dual; --¼¾
select to_char(sysdate,'mm') from dual; --ÔÂ
select to_char(sysdate,'dd') from dual; --ÈÕ
ddd ÄêÖеĵڼ¸Ìì
WW ÄêÖеĵڼ¸¸öÐÇÆÚ
W ¸ÃÔÂÖеڼ¸¸öÐÇÆÚ
D ÖÜÖеÄÐÇÆÚ¼¸
hh Сʱ(12)
hh24 Сʱ(24)
Mi ·Ö
ss Ãë ¡í3:È¡µ±Ç°ÈÕÆÚÊÇÐÇÆÚ¼¸ÖÐÎÄÏÔʾ:
SQL> select
to_char(sysdate,'day') from dual;
TO_CHAR(SYSDATE,'DAY')
----------------------
ÐÇÆÚËÄ ¡í4:¼ÙÈçÒ»¸ö±íÔÚÒ»¸ödateÀàÐ͵Ä×Ö¶ÎÉÏÃ潨Á¢ÁËË÷Òý£¬ÈçºÎʹÓÃ
alter session
set NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'
¡í5: µÃµ½µ±Ç°µÄÈÕÆÚ
select sysdate from dual; ¡í6: µÃµ½µ±ÌìÁ賿0µã0·Ö0ÃëµÄÈÕÆÚ
select trunc(sysdate) from dual; -- µÃµ½ÕâÌìµÄ×îºóÒ»Ãë
select trunc(sysdate) + 0.99999 from dual; -- µÃµ½Ð¡Ê±µÄ¾ßÌåÊýÖµ
select trunc(sysdate) + 1/24 from dual; select trunc(sysdate) + 7/24
from dual; ¡í7:µÃµ½Ã÷ÌìÁ賿0µã0·Ö0ÃëµÄÈÕÆÚ
select trunc(sysdate+1)
from dual; select trunc(sysdate)+1 from dual;
¡í8: ±¾ÔÂÒ»ÈÕµÄÈÕÆÚ
select trunc(sysdate,'mm') from dual;
¡í9:µÃµ½ÏÂÔÂÒ»ÈÕµÄÈÕÆÚ
select trunc(add_months(sysdate,1),'mm') from dual; ¡í10:·µ»Øµ±Ç°ÔµÄ×îºó
Ò»Ìì?
select last_day(sysdate) from dual;
select last_day(trunc(sysdate)) from dual;
select trunc(last_day(sysdate)) from dual;
select trunc(add_months(sys
Ïà¹ØÎĵµ£º
1.Ñ¡Ôñ²Ù×÷µÄÊý¾Ý¿â
Á¬½Óµ½·þÎñÆ÷Ö®ºó£¬Ê×ÏÈÐèҪѡÔñÒª½øÐвÙ×÷µÄÊý¾Ý¿â¡£Ê¹ÓÃPHPµÄMSSQLÀ©Õ¹¿âÖеÄmssql_select_db()º¯Êý¼´¿ÉʵÏÖÁ¬½Ó·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£¸Ãº¯Êý¸ñʽÈçÏ£º
bool mssql_select_db(string database_name[,resource link_identifier)
¸Ãº¯Êý¸÷²ÎÊýÒâÒ壺
a. ²ÎÊý database_nameΪָ¶¨µÄ·þÎñÆ÷ÉÏ¿ÉÓõÄÊý¾Ý ......
Another Look at MySQL 5.1's SQL Diagnostic Tools
http://dev.mysql.com/tech-resources/articles/mysql_51_diagnostic_tools.html Êý¾Ý¿âµÄÐÔÄܾö¶¨ÒòËØ£º
£¨1£©Êý¾Ý¿âµÄÉè¼Æ
£¨2£©SQL´úÂë ¿ÉÒÔÓÃÒÔϼ¸ÖÖ·½·¨À´½â¾öһЩÐÔÄÜÎÊÌ⣺
£¨1£©Ë÷Òý
£¨2£©Ë®Æ½·ÖÇø
£¨3£©ÁÐÊÊÓ¦µÄ±í
colum ......
¡¶SQL Sever 2005 Êý¾Ý¿â»ù´¡¼°Ó¦Óü¼Êõ½Ì³ÌÓëʵѵ ¡· ÖÜÆæ
SQL Server 2005µÄ°æ±¾£º
1. SQL Server 2005 Enterprise Edition ÆóÒµ°æ(32λºÍ64λ)
ÊÊÓÃÓÚ³¬´óÐÍÆóÒµ¡£Enterprise Edition ÊÇ×îÈ«ÃæµÄSQL Server°æ±¾£¬Êdz¬´óÐÍÆóÒµµÄÀíÏëÑ¡Ôñ£¬Äܹ»Âú×ã×ÔÓµÄÒªÇ󡣸ð汾»¹Í ......
Case¾ßÓÐÁ½ÖÖ¸ñʽ¡£¼òµ¥Caseº¯ÊýºÍCaseËÑË÷º¯Êý¡£
--¼òµ¥Caseº¯Êý
CASE sex
WHEN '1' THEN 'ÄÐ'
WHEN '2' THEN 'Å®'
ELSE 'ÆäËû' END
--CaseËÑË÷º¯Êý
CASE WHEN sex = '1' THEN 'ÄÐ'
  ......
Ëø
²éѯÆäËûÓû§µÄ±í <Óû§Ãû.±íÃû>
Ëø¶¨Ä£Ê½£º
Ðм¶Ëø
Ðб»ÅÅËûÐÔËø¶¨
ÔÚijÐеÄËø±»ÊÍ·Å֮ǰ£¬ÆäËûÓû§²»ÄÜÐ޸ĴËÐÐ
ʹÓÃcommit rollbackÃüÁîÊÍ·ÅËø
»ñÈ¡Ðм¶Ëø
ʹÓÃinsert¡¢updateÓï¾ä£¬×Ô¶¯ÉÏÐм¶Ëø
ʹÓÃselect...for update [of ÁÐÃû] Óï¾ä×Ô¶¯»ñÈ¡Ðм¶Ëø
ÔÚ±íµÄÒ»Ðлò¶àÐзÅÖÃÅÅËûËø£¬ÓÃÓÚ·ÀÖÎÆäË ......