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Êǹ«¿ªÊý¾Ý¿âÖÐ×Ô¶¯Éú³ÉµÄΨһ¶þ½øÖÆÊý×ÖµÄÊý¾ ......
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 code:
--convert×÷ÓãºÊ±¼äת×Ö·û´®
......
ÎÒÏÖÔÚÔÚÒ»¸öÒ³ÃæÉÏÓÐһЩ×Ö¶ÎÊÇÓÃajax»ñµÃµÄÖµ
ÕâЩֵµÄϱßÊÇÒ»¸ötable,tableÊDzéµÄÊý¾Ý¿âÖеÄһЩÊý¾Ý
¸ñʽÀàËÆÕâÑù
¶©µ¥µ¥ºÅ:select Èë¿âʱ¼ä:Îı¾ ³ö¿âʱ¼ä:Îı¾ ¿Í»§Ãû:Îı¾ ¿Í»§µç»°:Îı¾
table
tr
td td td td
/tr
tr
td td td td
/tr
Ñ¡ÔñÉϱߵĶ©µ¥µ¥ºÅ,È»ºóÈë¿âʱ¼ä,³ö¿âʱ¼ä,¿Í»§Ãû,¿Í»§ ......
ÓÐÒ»¸ö¹ØÓÚн¨(create)Ö鱦ÐÅÏ¢µÄÒ³Ãæ£¬Ò»ÑùÖ鱦¿ÉÄܲ»º¬×êʯ£¬Ò²¿ÉÄܺ¬¶à¿î×êʯ£¬ËùÒÔÎÒÔÚÕâ¸öÒ³ÃæÉÏÌí¼ÓÁËÒ»¸ö°´Å¥£¬Èç¹ûÓû§µã»÷Õâ¸ö°´Å¥£¬Ò³Ãæ¾Í»áÔö¼Ó¼¸¸öÎı¾¿ò£¬ÓÃÀ´ÊäÈëij¿î×êʯµÄÐÅÏ¢¡£
<g:remoteLink action="addOneMoreDiamond" update="mess">Add One Diamond</g:remoteLink> ......
СµÜÔÚѧϰ¹ý³ÌÖÐÅö¼ûÁËÒ»¸öÎÊÌâ¡£ÓÐÒ»Ïî¡°Ïêϸ˵Ã÷¡±ÊôÐÔ£¬Õâ¸öÊôÐÔÓû§¿ÉÄÜ»áÌîÈëºÜ¶àµÄ×Ö·û£¬Ð¡µÜÓÃÁË<textarea>¡£ÔÚʹÓÃAjaxģʽÌύʱ³öÏÖÁËÎÊÌâ¡£µ±Óû§ÔÚ<textarea>ÖÐÊäÈëµÄ×Ö·û½ÏÉÙʱ£¬¿ÉÒÔÕý³£Íê³ÉÌá½»¹¤×÷£¬µ«Êǵ±<textarea>ÖÐ×Ö·û½Ï¶àʱ£¬ÔÚIEä¯ÀÀÆ÷Ï»á³öÏÖ¡°Î´ÖªÃû³Æ¡±ºÍ¡°Ã»ÓÐȨÏÞ¡±µÄJS´í ......
×öÒ»¸öwapÍøÕ¾£¬C#ÓïÑÔ VS2005µÄÒÆ¶¯web´°¿Ú ÖÆ×÷ sql2000Êý¾Ý¿â
ÎÒ×Ô¼ºÃ»ÓзþÎñÆ÷£¬ Òª×âÓûòÍйÜʲôÑùµÄ ·þÎñÆ÷À´·ÅÎÒµÄÍøÕ¾°¡·?
¿Õ¼äÒªÇóÊÇʲôÑùµÄ°¡·£¿
»¹ÓÐ2Сʱϰ෣¬£¬£¬£¬£¬£¬£¬£¬£¬£¬£¬£¬
up...........................˸æËßÎÒÏÂÄØ £¿~
À´Ò»¸öÈË£¬ ¸ø·Ö£¡ ......