Re: Unable to fetch Timpstamp datatype using OCI layer

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 10 Aug 2007 11:47:27 +0200
Message-ID: <f9hc7e$qr0$2@news1.zwoll1.ov.home.nl>

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

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.

-- Regards, Frank van Bortel

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

iD8DBQFGvDQvLw8L4IAs830RAq2xAJ9A/ocB41ezPP2tQLa0LYtDXkIdiwCeMF6Y NZPEouueie/h+C0AdxjK/fg=
=E155
-----END PGP SIGNATURE----- Received on Fri Aug 10 2007 - 04:47:27 CDT