MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ
- depth:
- 0
hitachijoho
Åê¹Æ¿ô: 53
¤¤¤Ä¤â¤ªÀ¤ÏäˤʤäƤª¤ê¤Þ¤¹¡£
º£¡¢Excle¥Õ¥¡¥¤¥ë¤«¤éMS SQL Server 2005¤Ë¥Ç¡¼¥¿¤Î°Ü¹Ô¤Î¥Æ¥¹¥È¤ò¤ä¤Ã¤Æ¤Þ¤¹¤¬¡¢²¼µ¤ÎÆó¤Ä¤Îbug¤Ïȯ¸«¤µ¤ì¤Þ¤·¤¿¤¬¡¢ÂбþÊýË¡¤Ï¤´¶µ¼ø¤Î¤Û¤É¡¢¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
¡Excle¤Îcell¡Ö2009/04/06 11:44:59.047¡×¤ò¢ÍMS SQL Server 2005¤Îtable¤ÎDateTime¥Ç¡¼¥¿·¿¤Îcloum¤Ë°Ü¹Ô¤·¤¿½ê¡¢DateTime¥Ç¡¼¥¿·¿¤Îcloum1¤ÎÃͤϡÖ2009/04/06 11:44:59.000¡×¤È¤Ê¤ê¤Þ¤·¤¿¡£
¢¨º£¤ÎÀßÄêÊýË¡¡§³ºÅö¡Ö¥Î¡¼¥ÉÆÃÀ¡×¤Î¡ÖÁ´È̡פΡÖ°À¡×¤Î¥Ç¡¼¥¿¥¿¥¤¥×¤òStringDate¤òÁªÂò¤·¤Þ¤·¤¿¡£
¢Excle¤Îcell¡Ö0.0274¡×¤ò¢ÍMS SQL Server 2005¤Îtable¤Îmoney¥Ç¡¼¥¿·¿¤Îcloum¤Ë°Ü¹Ô¤·¤¿½ê¡¢money¥Ç¡¼¥¿·¿¤Îcloum¤ÎÃͤϡÖ0.0270¡×¤È¤Ê¤ê¤Þ¤·¤¿¡£
¢¨º£¤ÎÀßÄêÊýË¡¡§³ºÅö¡Ö¥Î¡¼¥ÉÆÃÀ¡×¤Î¡ÖÁ´È̡פΡÖ°À¡×¤Î½ñ¼°¤¬¡ÖN10.3¡×¤Ç¡¢¡ÖÃ͡פη׻»ÃͤÏVal(Excle¤Îcell¡Ö0.0274¡×,'N10.4')¤ÇÀßÄꤷ¤Þ¤·¤¿¡£
¾åµ¤ÎÀßÄê¤Ï¤ê¤ë¤Ç¤·¤ç¤¦¤«¡©
¤´²óÅú¤Î¤Û¤É¡¢¤è¤í¤·¤¯¤ª´ê¤¤Ãפ·¤Þ¤¹¡£
º£¡¢Excle¥Õ¥¡¥¤¥ë¤«¤éMS SQL Server 2005¤Ë¥Ç¡¼¥¿¤Î°Ü¹Ô¤Î¥Æ¥¹¥È¤ò¤ä¤Ã¤Æ¤Þ¤¹¤¬¡¢²¼µ¤ÎÆó¤Ä¤Îbug¤Ïȯ¸«¤µ¤ì¤Þ¤·¤¿¤¬¡¢ÂбþÊýË¡¤Ï¤´¶µ¼ø¤Î¤Û¤É¡¢¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
¡Excle¤Îcell¡Ö2009/04/06 11:44:59.047¡×¤ò¢ÍMS SQL Server 2005¤Îtable¤ÎDateTime¥Ç¡¼¥¿·¿¤Îcloum¤Ë°Ü¹Ô¤·¤¿½ê¡¢DateTime¥Ç¡¼¥¿·¿¤Îcloum1¤ÎÃͤϡÖ2009/04/06 11:44:59.000¡×¤È¤Ê¤ê¤Þ¤·¤¿¡£
¢¨º£¤ÎÀßÄêÊýË¡¡§³ºÅö¡Ö¥Î¡¼¥ÉÆÃÀ¡×¤Î¡ÖÁ´È̡פΡÖ°À¡×¤Î¥Ç¡¼¥¿¥¿¥¤¥×¤òStringDate¤òÁªÂò¤·¤Þ¤·¤¿¡£
¢Excle¤Îcell¡Ö0.0274¡×¤ò¢ÍMS SQL Server 2005¤Îtable¤Îmoney¥Ç¡¼¥¿·¿¤Îcloum¤Ë°Ü¹Ô¤·¤¿½ê¡¢money¥Ç¡¼¥¿·¿¤Îcloum¤ÎÃͤϡÖ0.0270¡×¤È¤Ê¤ê¤Þ¤·¤¿¡£
¢¨º£¤ÎÀßÄêÊýË¡¡§³ºÅö¡Ö¥Î¡¼¥ÉÆÃÀ¡×¤Î¡ÖÁ´È̡פΡÖ°À¡×¤Î½ñ¼°¤¬¡ÖN10.3¡×¤Ç¡¢¡ÖÃ͡פη׻»ÃͤÏVal(Excle¤Îcell¡Ö0.0274¡×,'N10.4')¤ÇÀßÄꤷ¤Þ¤·¤¿¡£
¾åµ¤ÎÀßÄê¤Ï¤ê¤ë¤Ç¤·¤ç¤¦¤«¡©
¤´²óÅú¤Î¤Û¤É¡¢¤è¤í¤·¤¯¤ª´ê¤¤Ãפ·¤Þ¤¹¡£
Åêɼ¿ô:0
Ê¿¶ÑÅÀ:0.00
Åê¹Æ¥Ä¥ê¡¼
-
MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ
(hitachijoho, 2010-8-25 0:23)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (Jiro123, 2010-8-25 11:58)
-
Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ
(hitachijoho, 2010-8-25 13:07)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (Jiro123, 2010-8-25 13:22)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (hitachijoho, 2010-8-25 16:38)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (hitachijoho, 2010-8-25 20:33)
-
Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ
(jBOLTer, 2010-8-26 10:08)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (Jiro123, 2010-8-26 11:00)
-
Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ
(hitachijoho, 2010-8-26 12:20)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (Jiro123, 2010-8-26 13:28)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (jBOLTer, 2010-8-26 13:50)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (hitachijoho, 2010-8-26 16:23)
-
Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ
(hitachijoho, 2010-8-26 16:30)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (Jiro123, 2010-8-26 16:37)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (jBOLTer, 2010-8-26 16:57)
-
Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ
(hitachijoho, 2010-8-26 17:23)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (Jiro123, 2010-8-26 17:43)
-
Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ
(hitachijoho, 2010-8-26 18:28)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (Jiro123, 2010-8-26 18:50)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (hitachijoho, 2010-8-26 19:25)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (hitachijoho, 2010-8-26 19:27)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (hitachijoho, 2010-8-26 19:32)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (hitachijoho, 2010-8-26 19:36)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (hitachijoho, 2010-8-27 17:09)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (jBOLTer, 2010-8-27 18:09)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (hitachijoho, 2010-8-27 18:53)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (hitachijoho, 2010-8-27 19:00)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (sndirect, 2010-8-31 11:36)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (hitachijoho, 2010-8-31 19:00)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (jBOLTer, 2010-9-1 10:18)
- Re: MS SQL Server 2005 ¤Îmoney,datetime¤Î¥Ç¡¼¥¿·¿¤ÎÊÑ´¹¤Ë¤Ä¤¤¤Æ (hitachijoho, 2010-9-1 12:04)