Обсуждение: Bad timestamp external representation '2001-05-11 00.00.00'

Hi all,

When trying to insert into a table I obtain this error :

An error occured at: 15/03/2002 15.04.41:
-2147467259: Error while executing the query;
ERROR:  Bad timestamp external representation '2001-05-11 00.00.00'

Is this dot notation of date time not supported? I cannot change directly my
inserton query, so is there a way to enable this notation ( maybe
configuring locale ? ) ?

Thanks, Kako. --

> ERROR:  Bad timestamp external representation '2001-05-11 00.00.00'
> Is this dot notation of date time not supported? I cannot change directly my
> inserton query, so is there a way to enable this notation ( maybe
> configuring locale ? ) ?

Hmm. This is the first report I've had (or at least that I can recall)
of using dot notation for time fields. PostgreSQL recognizes dots for
year/month/day fields.

It will require some source code changes to make this work for you. *OR*
you should use to_date() to read in the data, which seems a much better
choice ;) When you said that you cannot change the insertion query, do
you mean that you cannot change the query itself, or cannot change the
data going into the query? You've *got* to have some control over one or
the other, right?

Where are you located? Is this a common notation in that part of the
world?

                      - Thomas