Thread: problem with timestamps ?

problem with timestamps ?

From
Mike Haberman
Date:
I am running 7.0 and for columns that have type 'timestamp' 
the values end up with the format of  year-month-day HH:MM:SS-[0-n]

e.g.   2000-12-05 15:58:12-06
   the trailing -n (e.g. -06) is killing the JDBC driver.
   Is there a work around.  No matter what I Insert, a trailing   -0n gets appended.

   thanks
   mike


Re: problem with timestamps ?

From
Thomas Lockhart
Date:
> I am running 7.0 and for columns that have type 'timestamp'
> the values end up with the format of  year-month-day HH:MM:SS-[0-n]

afaik there is a newer JDBC driver which copes with this.
                  - Thomas