ADO Timestamps

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kevin@c3amulet.com - 23 Feb 2005 22:11 GMT

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.

Reply to this Message

Val Mazur - 26 Feb 2005 02:12 GMT

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

Signature

Val Mazur
Microsoft MVP

http://xport.mvps.org

> 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
[quoted text clipped - 6 lines]
>
> thanks, Kevin.

Reply to this Message

VB Forum / Database Access / February 2005

ADO Timestamps