Re: Unable to fetch Timpstamp datatype using OCI layer

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 11 Aug 2007 13:23:22 +0200
Message-ID: <f9k679$tvk$1@news5.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Rohit wrote:

> On Aug 10, 2:47 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
> wrote:
> Rohit wrote:

>>>> On Aug 9, 1:22 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
>>>> wrote:
>>>> Also, local settings dictate how your data will be converted:
>>>> "where t1>=:1" *will* do a conversion - always do your
>>>> own conversions! Use the to_timestamp function:http://download-east.oracle.com/docs/cd/B14117_01/server.101/b10759/f...
>>>> I tried both of your suggestions, but I didnt get results.
>>>> Earlier I was using
>>>> insert into tstamp9 values(timestamp '2007-08-08 10:00:00.000000000');
>>>> later on I tried with to_timestamp, but I was having same results.
>>>> I also tried t1>=:1. But in this case I was not able to fetch data.

> I fail to see the format mask in use, nor do I see an alter session
> statement.
> 

> I think for timestamp format mask is default, that is (YEAR-MM-DD > HH:MI:SS.FMS) I think what you think may be one of the sources of error. I stated: always do your own conversions, do not rely on defaults.

• -- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGvZwqLw8L4IAs830RAu5YAKCQt6VXrZBDW2aIhFbBXyCkVrX77wCgkmeB x4YZGs1shbF3pGmdO/RGMPE=
=f4Rt
-----END PGP SIGNATURE----- Received on Sat Aug 11 2007 - 06:23:22 CDT