On Aug 10, 2:47 pm, Frank van Bortel <frank.van.bor..._at_gmail.com>
wrote:
> -----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-----
I think for timestamp format mask is default, that is (YEAR-MM-DD
HH:MI:SS.FMS)
Received on Fri Aug 10 2007 - 06:19:32 CDT
