473,511 Members | 10,195 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ʱ¼äÀàÐÍ ²åÈ룬ת»¯

cmd.parameter.add("@firstOnDuty",sqldbtype.datetim e,"firstOnduty")

cmd.parameter(0).value=cdate(firstOnDuty.text)
Èç¹û firstOnDuty.text=9:00 ,cdate(firstOnDuty.text)=#9:00:00 AM#,
ϵͳ»á±¨´í"SqlDateTime Òç³ö¡£±ØÐë½éÓÚ 1/1/1753 12:00:00 AM ºÍ 12/31/9999
11:59:59 PM Ö®¼ä"
Èç¹ûcdate(firstOnduty.text)=#1/11979 9:00:00 Am#,ϵͳ²»»á³ö´í¡£
Èç¹ûÎÒÔÚsql server ÖÐÖ±½ÓдÈë9£º00£¬ÏµÍ³»á×Ô¶¯×ª»»Îª9:00:00,²»»á±¨´í
ËùÒÔÎÒÈÏΪÊÇsqldbtype.datetime µÄÎÊÌ⣬ÎÒÖ»Ïë²åÈëʱ¼ä£¬²»Ïë²åÈëÈÕÆÚ£¬ÇëÎÊÎÒ
¸ÃÈçºÎ×ö£¿
лл£¡£¡
Nov 17 '05 #1
0 1965

This thread has been closed and replies have been disabled. Please start a new discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.