Solved

ADO SQL Storing Milliseconds

Posted on 1998-07-16
2
281 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 100 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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

747 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now