Re: SQL Server 2005 ODBC - DateTime Problem


"Vlad Gerchikov" <vgerchikov@xxxxxxxxxx> wrote in message
news:%23A9kU0T7GHA.3620@xxxxxxxxxxxxxxxxxxxxxxx
Hi there,
I hope somebody here can help me, as I have run out of ideas.
I am trying to export some data to SQL Server 2005 via ODBC. The data
consists, for testing purposes, of a single row and a single column. The
value itself is time, i.e. 08:20:54 (hh:mm:ss). I have created a test
table in SQL Server with a column of type DateTime. In the C++
application, I am calling the SQLBindParameter() function and I pass the
ValueType parameter (4th parameter) as SQL_C_TYPE_TIME.

Is the column defined in the table as a DATETIME or a SMALLDATETIME? Sounds
like you have a SMALLDATETIME which rounds to the nearest minute.


.

Relevant Pages

  • Re: SmallDateTime
    ... Underneath the hood, it creates a SqlParameter of the proper type, so you ... Here is your corrected string: ... The second example will strongly type for SQL Server and will definitely ... convert from datetime to smalldatetime... ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Data Driven Query - Lookup where Clause
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > im trying to write a lookup query for a Data driven Query. ... > im trying to compare a string value from a text file to a smalldatetime value. ... > Ive tried converting the textfile value to '27/02/2004' but am getting nowhere ...
    (microsoft.public.sqlserver.dts)
  • Re: Moving Data Without CURSORS or Looping.
    ... SQL Server Books Online - within the SQL Server program group) for more ... as I read the BOL my procedural mind can only> come up with using a cursor to solve this. ... > wrk_days_per_week smallint NULL, ... > line_start_date smalldatetime NULL, ...
    (microsoft.public.sqlserver.programming)
  • Re: Cross Tab Query Help!
    ... Have you tried a SQL Server news group? ... This is my first query: ... FROM dbo.ViwOEE_Source LEFT OUTER JOIN (SELECT SeqNum as Seq, MachNum ... WHERE (DateCode BETWEEN CAST('20060713' AS smalldatetime) ...
    (microsoft.public.access.queries)
  • Re: .Net DateTime type and SQL DateTime type
    ... For SQL Server 2005 questions, ... Human has a DateOfBirth property of the type DateTime. ... > Then that I persist my you Human to the database. ...
    (microsoft.public.sqlserver.programming)