Date time conversion related

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

abcd - 26 Jul 2006 03:13 GMT

I get following error from my ADO code

"[Sybase][ODBC Driver][Adaptive Server Anywhere]Cannot convert 7/24/2006
4:05:07 PM to a timestamp"

My sybase table has column with data type "timestamp"

I want to filter the table based on the time I pass from my ADO code.

any clues

Reply to this Message

Jan Hyde - 26 Jul 2006 08:58 GMT

"abcd" <abcd@abcd.com>'s wild thoughts were released on Tue,
25 Jul 2006 19:13:26 -0700 bearing the following fruit:

>I get following error from my ADO code
>
[quoted text clipped - 6 lines]
>
>any clues

You shouldn't be trying to insert anything into a timestamp
field, it should be updated automatically.

Jan Hyde (VB MVP)

Signature

Nick was walking down the street with a computer under one arm, a photocopier under the other and a desk strapped to his back. A policeman stopped him and said, Im placing you under arrest. Why? asked Nick. For impersonating an office, sir, replied the policeman.

Reply to this Message

abcd - 26 Jul 2006 16:56 GMT

I am not trying to insert. I am reading it and based on that value want to
fire a query in another table....

> "abcd" <abcd@abcd.com>'s wild thoughts were released on Tue,
> 25 Jul 2006 19:13:26 -0700 bearing the following fruit:
[quoted text clipped - 14 lines]
>
> Jan Hyde (VB MVP)

Reply to this Message

Dmitriy Antonov - 26 Jul 2006 18:39 GMT

>I am not trying to insert. I am reading it and based on that value want to
>fire a query in another table....
[quoted text clipped - 17 lines]
>>
>> Jan Hyde (VB MVP)

I don't know Oracle but if timestamp there is something similar to timestamp
in MSSQL, then this data type has no connection to date and time - this is,
probably, the reason for this problem. You should read Oracle's
documentation on what the data type "timestamp" is. Most likely it is just
an integer value and all its meaning is uniqueness within the table or
within the DB.

Dmitriy.

Reply to this Message

Jan Hyde - 27 Jul 2006 08:57 GMT

"abcd" <abcd@abcd.com>'s wild thoughts were released on Wed,
26 Jul 2006 08:56:58 -0700 bearing the following fruit:

>I am not trying to insert. I am reading it and based on that value want to
>fire a query in another table....

Ah, then I suspect Dmitriy has the nail on the head. Your
expecting it to be a datetime field and AFAIK it isn't.

J

>> "abcd" <abcd@abcd.com>'s wild thoughts were released on Tue,
>> 25 Jul 2006 19:13:26 -0700 bearing the following fruit:
[quoted text clipped - 12 lines]
>> You shouldn't be trying to insert anything into a timestamp
>> field, it should be updated automatically.

>> Jan Hyde (VB MVP)

Jan Hyde (VB MVP)

Signature

Have you heard about the downhill skier who was an exhibitionist?
He was arrested for in-descent exposure. (Richard Lederer)

Reply to this Message

VB Forum / Database Access / July 2006

Date time conversion related