access ÈÕÆÚ select,insert ¸ñʽ
ʱ¼ä¸ñʽ£¿
±ðÄÃcoldatatime ºÍCTimeʲôµÄ˵Ê¡£¡£ËµµãÓÐÓõġ£¡£¡£ËùÓлý·ÖÏàËÍ
ʲôÎÊÌ⣿
format(#2009-1-1#,'yyyy-mm-dd')£¿
select #2009-1-1#
insert into table (mydate) values (#2009-09-21#);
Óû§×Ô¶¨ÒåÈÕÆÚ/ʱ¼ä¸ñʽ (Format º¯Êý)
ÏÂÃæ±í¸ñ±êʶһЩ¿ÉÓÃÀ´´´½¨Óû§×Ô¶¨ÒåÈÕÆÚ/ʱ¼ä¸ñʽµÄ×Ö·û£º
×Ö·û ˵Ã÷
(:) ʱ¼ä·Ö¸ô·û¡£ÔÚһЩÇøÓò£¬¿ÉÄÜÓÃÆäËû·ûºÅÀ´µ±Ê±¼ä·Ö¸ô·û¡£¸ñʽ»¯Ê±¼äֵʱ£¬Ê±¼ä·Ö¸ô·û¿ÉÒÔ·Ö¸ôʱ¡¢·Ö¡¢Ã롣ʱ¼ä·Ö¸ô·ûµÄÕæÕý×Ö·ûÔÚ¸ñʽÊä³öʱȡ¾öÓÚϵͳµÄÉèÖá£
(/) ÈÕÆÚ·Ö¸ô·û¡£ÔÚһЩÇøÓò£¬¿ÉÄÜÓÃÆäËû·ûºÅÀ´µ±ÈÕÆÚ·Ö¸ô·û¡£¸ñʽ»¯ÈÕÆÚÊýֵʱ£¬ÈÕÆÚ·Ö¸ô·û¿ÉÒÔ·Ö¸ôÄê¡¢Ô¡¢ÈÕ¡£ÈÕÆÚ·Ö¸ô·ûµÄÕæÕý×Ö·ûÔÚ¸ñʽÊä³öʱȡ¾öÓÚϵͳÉèÖá£
c ÒÔ ddddd À´ÏÔʾÈÕÆÚ²¢ÇÒÒÔ ttttt À´ÏÔʾʱ¼ä¡£Èç¹ûÏëÏÔʾµÄÊýÖµÎÞСÊý²¿·Ö£¬ÔòÖ»ÏÔʾÈÕÆÚ²¿·Ö£¬Èç¹ûÏëÏÔʾµÄÊýÖµÎÞÕûÊý²¿·Ö£¬ÔòÖ»ÏÔʾʱ¼ä²¿·Ö¡£
d ÒÔûÓÐÇ°µ¼ÁãµÄÊý×ÖÀ´ÏÔʾÈÕ (1 – 31)¡£
dd ÒÔÓÐÇ°µ¼ÁãµÄÊý×ÖÀ´ÏÔʾÈÕ (01 – 31)¡£
ddd ÒÔ¼òдÀ´±íʾÈÕ (Sun –Sat)¡£
dddd ÒÔÈ«³ÆÀ´±íʾÈÕ (Sunday –Saturday)¡£
ddddd ÒÔÍêÕûÈÕÆÚ±íʾ·¨ÏÔʾ£¨°üÀ¨Äê¡¢Ô¡¢ÈÕ£©£¬ÈÕÆÚµÄÏÔʾҪÒÀϵͳµÄ¶ÌÈÕÆÚ¸ñʽÉèÖöø¶¨¡£È±Ê¡µÄ¶ÌÈÕÆÚ¸ñʽΪ m/d/yy¡£
dddddd ÒÔÍêÕûÈÕÆÚ±íʾ·¨ÏÔʾÈÕÆÚϵÁÐÊý£¨°üÀ¨Äê¡¢Ô¡¢ÈÕ£©£¬ÈÕÆÚµÄÏÔʾҪÒÀϵͳʶ±ðµÄ³¤ÈÕÆÚ¸ñʽ¶ø¶¨¡£È±Ê¡µÄ³¤ÈÕÆÚ¸ñʽΪ mmmm dd, yyyy¡£
aaaa Óëdddd Ò»Ñù£¬ËüÖ»ÊǸÃ×Ö·û´®µÄ±¾µØ»¯°æ±¾¡£
w ½«Ò»ÖÜÖеÄÈÕÆÚÒÔÊýÖµ±íʾ£¨1 ±íÐÇÆÚÈÕ~ 7±íÐÇÆÚÁù£©¡£
ww ½«Ò»ÄêÖеÄÐ
Ïà¹ØÎÊ´ð£º
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......
<?php
include("adodb/adodb.inc.php");
$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......
×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ
µ±Êý¾Ý¿â×Ö¶ÎΪ¡ ......
ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()
¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...
Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!
......
ЩÁËÒ»¸ö¼òµ¥ÍøÕ¾£¬ÓõÄÊÇaccessÊý¾Ý¿â£¬·¢²¼µ½ÓòÃû¿Õ¼äÉÏÈ¥ºó£¬¿ª³¡Ò³ÏÔʾÕý³££¬ÆäÓà´æÔÚÊý¾Ý¿âÁ´½ÓÊý¾ÝµÄÅ׳öÒì³££¬
Ìáʾ£º'c:\windows\system32\inetsrv\data\longdeng.mdb'²»ÊÇÒ»¸öÓÐЧµÄ·¾¶¡£ È·¶¨ ......