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,ÐèÒª¼ÓÔØPHPµÄMSSQLÀ©Õ¹¡£¾ßÌå·½·¨ÊÇ´ò¿ªphp.iniÎļþ£¬ÕÒµ½ÏÂÃæÒ»ÐдúÂ룺
;extension=php_mssql.dll
È¥µôÐÐÊ׵ķֺţ¬È»ºó±£´æΪphp.iniÎļþ£¬¼´Íê³ÉPHPµÄMSSQLÀ©Õ¹µÄ¼ÓÔØ¡£
2.PHPÁ¬½ÓSQL ServerµÄ±ØÒªÌõ¼þ
a. SQL Server·þÎñÆ÷µÄÖ÷»úÃû³Æ¡£
b. ÔÊÐí¶Ô·þÎñÆ÷ ......
×Ô£ºhttp://blog.csdn.net/AJAXBloger/archive/2007/08/29/1764506.aspx
×Ó²éѯ£º
ʹÓÃ×Ó²éѯµÄÔÔò
1.Ò»¸ö×Ó²éѯ±ØÐë·ÅÔÚÔ²À¨ºÅÖС£
2.½«×Ó²éѯ·ÅÔڱȽÏÌõ¼þµÄÓÒ±ßÒÔÔö¼Ó¿É¶ÁÐÔ¡£
×Ó²é
ѯ²»°üº¬ ORDER BY ×Ӿ䡣¶ÔÒ»¸ö SELECT Óï¾äÖ»ÄÜÓÃÒ»¸ö ORDER BY ×Ӿ䣬
²¢ÇÒÈç¹ûÖ¸¶¨ÁËËü¾Í±ØÐë·ÅÔÚÖ÷
SELECT Óï¾äµÄ×î ......
char¡¢varchar¡¢textºÍnchar¡¢nvarchar¡¢ntext
charºÍvarcharµÄ³¤¶È¶¼ÔÚ1µ½8000Ö®¼ä£¬ËüÃǵÄÇø±ðÔÚÓÚcharÊǶ¨³¤×Ö·ûÊý¾Ý£¬¶øvarcharÊDZ䳤×Ö·ûÊý¾Ý¡£Ëùν¶¨³¤¾ÍÊdz¤¶È¹Ì¶¨
µÄ£¬µ±ÊäÈëµÄÊý¾Ý³¤¶ÈûÓдﵽָ¶¨µÄ³¤¶Èʱ½«×Ô¶¯ÒÔÓ¢ÎÄ¿Õ¸ñÔÚÆäºóÃæÌî³ä£¬Ê¹³¤¶È´ïµ½ÏàÓ¦µÄ³¤¶È£»¶ø±ä ......
¡¶SQL Sever 2005 Êý¾Ý¿â»ù´¡¼°Ó¦Óü¼Êõ½Ì³ÌÓëʵѵ ¡· ÖÜÆæ
SQL Server 2005µÄ°æ±¾£º
1. SQL Server 2005 Enterprise Edition ÆóÒµ°æ(32λºÍ64λ)
ÊÊÓÃÓÚ³¬´óÐÍÆóÒµ¡£Enterprise Edition ÊÇ×îÈ«ÃæµÄSQL Server°æ±¾£¬Êdz¬´óÐÍÆóÒµµÄÀíÏëÑ¡Ôñ£¬Äܹ»Âú×ã×ÔÓµÄÒªÇ󡣸ð汾»¹Í ......
oracle±í·ÖÇø
oracleÔÊÐíÓû§¶Ô±í½øÐнøÒ»²½¹æ»®£¬¼´¶Ô±í½øÐнøÒ»²½²ð·Ö£¬½«±í·Ö³ÉÈô¸É¸öÂß¼²¿·Ö£¬Ãð¸ö²»·Á³ÆÆäΪ±í·ÖÇø
·¶Î§·ÖÇø£º
¸ù¾Ý±íÖÐÁÐÖµµÄ·¶Î§½øÐзÖÇø
Óï·¨£ºPartition by range(×Ö¶ÎÃû)(
Partition ·ÖÇøÃû values less than (60), --60ÒÔÏÂ
Partition ·ÖÇøÃû values less than (75), --60¡«75
......