timestamp datatype

2006-06-28 Thread Loo, Peter # PHX
Hi All, I am getting the following error when I try INSERTing selected rows from one database to another. ORA-01843: not a valid month Do I have to use to_date() and if so, has anyone done this with bind variables? I am using bind variables to INSERT the selected rows. Below is the code

RE: timestamp datatype

2006-06-28 Thread Andy Hassall
://www.andyh.co.uk http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool -Original Message- From: Loo, Peter # PHX [mailto:[EMAIL PROTECTED] Sent: 28 June 2006 16:14 To: DBI-Users Subject: timestamp datatype Hi All, I am getting the following error when I try INSERTing

DBD::Oracle1.13 Supports TIMESTAMP datatype of Oracle9i, recommen dation.

2003-05-30 Thread XIE,KE-XIAN (HP-China,ex2)
Hi bunce, I have compiled your DBD::Oracle1.13 on HP-UX11i together with perl 5.8.0 64bit, DBI 1.30 64bit. When I use dbi to fetch the data typed of TIMESTAMP of Oracle9i, during the prepare station, error occurs that data type 187 is not supported. And I search the file oci8.c and

Re: DBD::Oracle1.13 Supports TIMESTAMP datatype of Oracle9i, recommen dation.

2003-05-30 Thread Tim Bunce
TIMESTAMP will be supported in the next release. Thanks. Tim. On Thu, May 29, 2003 at 04:45:23PM +0800, XIE,KE-XIAN (HP-China,ex2) wrote: Hi bunce, I have compiled your DBD::Oracle1.13 on HP-UX11i together with perl 5.8.0 64bit, DBI 1.30 64bit. When I use dbi to fetch the data typed