pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
ODBC DATE PROBLEM 2+ messages / 2 participants [nested] [flat]
* ODBC DATE PROBLEM @ 1998-08-04 16:01 Pierluigi <pgsql@sif.it> 0 siblings, 1 reply; 2+ messages in thread From: Pierluigi @ 1998-08-04 16:01 UTC (permalink / raw) To: pgsql-interfaces I use the europena DATE format on my backend, running postmaster with -o -e option. When I get from access or excel date fileds i always get dates back in this format: year-month-day when I would (should??) get them back in the european format os within pgsql. day-month-year. How can I fix the problem?? I have 248 version number installed. Thanks in advance Pierluigi ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [INTERFACES] ODBC DATE PROBLEM @ 1998-08-06 03:05 Stephen Davies <scldad@sdc.com.au> parent: Pierluigi <pgsql@sif.it> 0 siblings, 0 replies; 2+ messages in thread From: Stephen Davies @ 1998-08-06 03:05 UTC (permalink / raw) To: Pierluigi <pgsql@sif.it>; +Cc: pgsql-interfaces I am not sure about Access but I use ODBC from Excel and VB. I leave my backend in default date mode (US private format) but rely on the ODBC driver to switch itself to ISO format (as I recall, this approach was decided by consensus a few months back). In VB, this seems to be converted to whatever I select in the Control Panel Regional Settings. Sometimes I also use the VB Format function to manipulate the raw input format. HTH, Stephen. ======================================================================== Stephen Davies Consulting scldad@sdc.com.au Adelaide, South Australia. Voice: 61-8-82728863 Computing & Network solutions. Fax: 61-8-82741015 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1998-08-06 03:05 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1998-08-04 16:01 ODBC DATE PROBLEM Pierluigi <pgsql@sif.it> 1998-08-06 03:05 ` Stephen Davies <scldad@sdc.com.au>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox