Re: ADO Timestamps

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Val Mazur (group51a_at_hotmail.com)
Date: 02/26/05 

Date: Fri, 25 Feb 2005 21:12:48 -0500

Hi Kevin,

I do not think there is such a function (I could be wrong), but you should
not worry about date and time format conversion if you use ADO. ADO work
through the provider and provider does all the job to
convert date and time values into proper format for the database. In a case
if you need to execute SQL statement all you need to do is to use Command
object with the parameters to execute actual SQL
statement. If you declare datetime parameters using proper datatype then it
will work fine 

-- 
Val Mazur
Microsoft MVP
http://xport.mvps.org
<kevin@c3amulet.com> wrote in message 
news:1109196687.264576.265120@o13g2000cwo.googlegroups.com...
> Hello, I am updating some SQL Server statements to Oracle and I've done
> this task about 6 years ago.  I'm sure that I used a function inside
> the SQL statement either called {TS} or {D} and this meant that the ADO
> subsystem converted the date syntax for me - and hence one statement.
> I've been googling for the last hour and can't find this info again.
> Was it all a dream!!??
>
> Any help much appreciatedd.
>
> thanks, Kevin.
>

Relevant Pages

  • Re: ADO Behaving VERY badly...
    ... > VB6 and VBScript to retrieve ADO Recordsets for a number of individual SQL ... > two second pause, and a few more statements will execute, then another ... It's not dependent on the SQL statement being issued, ... This database is pretty tight, normalized, and indexed ...
    (microsoft.public.data.ado)
  • filling a dataset with two tables using a single query
    ... Consider a SQL statement like this: ... In ADO, the following code will locate the record and if found, update both ... in two separate trips to the DB. ... Load the resultset as an untyped dataset or use a datareader. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Updatable View with ADO and Trigger INSTEAD OF
    ... By default ADO/ADO.NET will generate INSERT SQL statement based on ... statements in ADO with the Command object to execute actual INSERT ... "Martino" wrote in message ... > Is there a vay to force ADO to generate insert for the view and not for ...
    (microsoft.public.data.ado)
  • Re: SQL string problem
    ... You must "escape" any single quotes when sending SQL statements directly to ... SQL Server via ADO. ... Just pass your SQL statement through this function when opening your ... > truncated and is not passed to SQL server 2000 in a complete form. ...
    (microsoft.public.excel.programming)