Works ok here using "2003-12-17" and "17-12-2003"

Postgresql understand the same date , using both format

Bruno



2010/3/7 Viktor Szakáts <harbour...@syenar.hu>

> > I think you need to leave the sample as it was
> >
> > correct for english or "traditional" postgresql style
> > look this:
> >
> > Style Specification   Description     Example
> > ISO   ISO 8601/SQL standard   1997-12-17 07:37:16-08
> > SQL   traditional style       12/17/1997 07:37:16.00 PST
> > PostgreSQL    original style  Wed Dec 17 07:37:16 1997 PST
> > German        regional style  17.12.1997 07:37:16.00 PST
> >
>
> IMO we should follow ISO standard. Can you try with "2003-12-17" ?
>
> (SQL traditional style is ambiguous, so it's not good for us)
>
> Though if any one of these depend on postgres configuration,
> they are not good for us.
>
> (It's unbelievable that such basic problems are so poorly covered
> in SQL, which is supposed to be the paramount of database handling :/
> I'd rather like to think there is a solution, only we don't know it)
>
> Brgds,
> Viktor
>
> _______________________________________________
> Harbour mailing list (attachment size limit: 40KB)
> Harbour@harbour-project.org
> http://lists.harbour-project.org/mailman/listinfo/harbour
>
_______________________________________________
Harbour mailing list (attachment size limit: 40KB)
Harbour@harbour-project.org
http://lists.harbour-project.org/mailman/listinfo/harbour

Reply via email to