Solved

ADO SQL Storing Milliseconds

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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
push and Pull replication 31 48
disk usage reporting tools 27 57
Need some alteration to below mention query 2 13
Need to replicate a Log table 4 14
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
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.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

696 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