Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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·±ÌåÁ¬½Ó¼òÌåsqlserver2000

  ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......

ÇóACCESSÊý¾Ý¿â

      ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
  ¸øСµÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË

officeÍêÕ ......

ʹÓÃRepeater¶ÁÈ¡access±í£¬Ò³Ãæ´ò¿ª·Ç³£Âý

accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×ֶΠfrom ±í  ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËٶȣ¡
Ò»´ÎÈ«²¿¶ÁÍê ......

ASP+ACCESSÊä³öÎÊÌâ

ΪʲôÊä³ö½á¹ûÊÇÕâÑùÄØ£¿

%@ Page Language="VB" AutoEventWireup="false" aspcompat="true"  CodeFile="Default.aspx.vb" Inherits="_Default" % ......

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

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

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

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


......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ