From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'Brar Piening'" <Brar(at)gmx(dot)de>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Export "time-field" to text/html problem |
Date: | 2001-09-20 14:06:42 |
Message-ID: | 8568FC767B4AD311AC33006097BCD3D6338FB8@woody.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: Brar Piening [mailto:Brar(at)gmx(dot)de]
> Sent: 20 September 2001 14:53
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Export "time-field" to text/html problem
>
>
> Hi,
> whenever I try to execute a query which includes a table
> containing a column with data-type "time" to a html- or a
> text-file the current date is inserted before the time-value
> in the resulting table. This problem never appears when I
> execute the query to the screen. What's wrong?
>
Hi,
If I remember correctly, this is because Microsoft's ADO prepends the date
to the time. The data grid (==screen) fixes it again because it re-formats
dates/times into a non-ambiguous format (ISO something, I forget the number)
so that updates and deletes work properly. The exporters just export the
data as supplied by ADO.
I will look into fixing the exporters for the next release.
Thanks, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2001-09-21 09:44:57 | Re: Export "time-field" to text/html problem |
Previous Message | Brar Piening | 2001-09-20 13:52:49 | Export "time-field" to text/html problem |