sql,´Ó½ñÌìÆðÏÔʾ³ö±íÒ»ÖÐ15ÌìÄÚÈ˵ÄÉúÈÕ¡£ÒªÇó¸ÃÓï¾äÈκÎÔ·ݶ¼¿ÉʹÓÃ×¢Òâ¿çÄêÒ²¿ÉʹÓÃ
¼±Óã¬ÏÈл¹ýÁË£¬
±íÒ»¼Ç¼µÄÉúÈÕÊÇʲôÊý¾Ý£¿³öÉúÄêÔÂÈÕ£¿
select birthday from your_tab where birthday >= trunc(sysdate) and birthday <=trunc(sysdate+15);
´Ë´¦µÄbirthdayΪdateÐÍÊý¾Ý£¬Èç¹û²»ÊÇdateÐÍÊý¾Ý£¬Çë×÷ ......
ÓÐÁ½¸öORACLEÊý¾Ý¿â£¬A¸úB£¬·Ö±ðÓÐÒ»ÕűíA1ºÍB1,Á½Õűí×ֶζ¼Ò»Ñù¡£ÎÒÓÃ
select column_name from user_tab_columns where table_name='A1'
select column_name from user_tab_columns where table_name='B1'
µ«µÃµ½µÄÁ½¸ö½á¹û²»Ò»Ñù£¬²»ÖªµÀÊÇʲôÔÒò¡£¡£´ó¼ÒÓÐÓöµ½ÕâÖÖÇé¿öÂð£¿ÓÐûÓÐʲô½â¾ö°ì·¨£¿
×Ö¶ÎÊÇ¿ÉÒÔ»ñÈ ......
£¨1£©Èí¼þ°ü°²×°£º
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-4.1.1
gcc-c++-4.1.1
glibc-2.5-12
glibc-common-2.5
glibc-devel-2.5
libaio-0.3.106
libaio-devel-0.3.106
libgcc-4.1.1
libstdc++-4.1.1
libstdc++-devel 4 ......
×öOracleÊý¾Ý¿â¿ª·¢µÄ´óÏÀÄÜ˵˵Oracle¿ª·¢µÄÖ÷Òª¹¤×÷ÒÔ¼°Ïà¹Ø¹¤¾ßÂð£¿
ÒªÊÇÏë×öºÃOracle¿ª·¢Ó¦¸Ã¾ß±¸Ê²Ã´ÄÜÁ¦ÄØ£¿
лл£¬Ï£Íû´ó¼ÒÓ»Ô¾ÌÖÂÛ£¡
Õâ¸öÎÊÌâºÃÏñÖ»ÄÜ×öÕâ¸öµÄ²ÅÖªµÀÁË¡£¡£¡£°ïlz¶¥¡£¡£¡£ºÙºÙ¡£¡£
˳±ãת¸öÐÁ¿à·Ö¡£¡£¡£¡£ºÇºÇ¡£¡£
ÓëÊý¾Ý¿âÏà¹ØµÄ¹¤×÷£º³ÌÐòÔ±¡¢dbaµÈ
Ïà¹Ø¹¤¾ß£ºsqlplus¡¢pl/sql developer ......
ÔÚmysqlÖÐÓиöCONVERT_TZº¯Êý¡£¿ÉÒÔ¶Ôʱ²î½øÐÐת»»¡£¡£
ÔÚoracleÖÐÒ²´ËÏà¶ÔÓ¦µÄº¯ÊýÂð£¿
±ÈÈç ʱ¼ä²îÒ»Ì죺 select to_date('2001-01-01','yyyy-mm-dd')+1 from dual
{{-- ......
oracleÖÐSQL code:
select to_timestamp('2010-04-16 16:52:04.093','YYYY-MM-DD HH24:MI:SS.FF3') from dual;
½á¹ûÊÇ£º16-APR-10 04.52.04.093000000 PM
ÈçºÎÔÚSQL SERVER ÖÐʵÏÖÕâÑùµÄ¹¦ÄÜ
ÓóÌÐò´¦ÀíÒ²¿ÉÒÔ£¬¼±ÆðÀ´Ã»Ë¼Â·À²
·¢µ½sql server ÇøÎÊÎÊ¡£¡£
timestampÊǹ«¿ªÊý¾Ý¿âÖÐ×Ô¶¯Éú³ÉµÄΨһ¶þ½øÖÆÊý×ÖµÄÊý¾ ......