Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

php ʹÓà ADODB Á¬½ÓAccess µÄÎÊÌâ

<?php

include("adodb/adodb.inc.php");

$db = &NewADOConnection("access");
$access = realpath("Data.mdb");
$dsn = "Provider=Microsoft.J ......

MSHFelxGrid Óë ACCESS MEMOÀàÐÍ×ֶεÄÒÉÎÊ

×î½ü×¼±¸Îª¹«Ë¾ÍøÕ¾ÓÃVB×ö¸ö²úƷչʾÉú³É£¬Éú³É²¿·Ö»ù±¾Ã»ÎÊÌ⣬
ÎÊÌâ³öÏÖÔÚ²éѯ²¿·Ö£¬Ê¹ÓÃÁËMSHFelxGrid(DATAGrid²»ÄÜÂú×ã²Ù×÷ÐèÇó)£¬±¾À´ÒÔΪÊÕ¹¤ÁË£¬×òÌìÔٴβâÊÔµÄʱºò·¢ÏÖÁËÒÔÏÂÎÊÌâ

µ±Êý¾Ý¿â×Ö¶ÎΪ¡ ......

delphiÖÐACCESSµÄ×Ô¶¨Ò庯ÊýÔõôÓÃÄØ...

ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()

¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...

Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!


......

asp.netÁ´½ÓACCESSÊý¾Ý¿âÎÊÌ⣿

ЩÁËÒ»¸ö¼òµ¥ÍøÕ¾£¬ÓõÄÊÇaccessÊý¾Ý¿â£¬·¢²¼µ½ÓòÃû¿Õ¼äÉÏÈ¥ºó£¬¿ª³¡Ò³ÏÔʾÕý³££¬ÆäÓà´æÔÚÊý¾Ý¿âÁ´½ÓÊý¾ÝµÄÅ׳öÒì³££¬
Ìáʾ£º'c:\windows\system32\inetsrv\data\longdeng.mdb'²»ÊÇÒ»¸öÓÐЧµÄ·¾¶¡£ È·¶¨ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ