?
Solved

ADO SQL Storing Milliseconds

Posted on 1998-07-16
2
Medium Priority
?
332 Views
Last Modified: 2012-05-04
Using ADO with SQL, trying to store a datetime WITH fractions of a seconds (!dt="7/16/1998 12:58:01.1") gives a "Type Mismatch" error from ADO.  Same statement without the fraction works.  How can I store milliseconds WITHOUT using a SQL statement?
0
Comment
Question by:mdholaki
2 Comments
 

Author Comment

by:mdholaki
ID: 1091784
Edited text of question
0
 
LVL 2

Accepted Solution

by:
Wiz_of_Oz earned 200 total points
ID: 1091785
datetime defaults to January 1, 1900, 12:00:00:000AM
this string has been extracted from the SQL Books on line, so it should works well...
looking at your source code the error is located at the separation character you use between seconds and milliseconds...
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

589 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question