Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: Re: Cannot get date fields to import from PostgreSQL via ODBC


From   Dave Ewart <davee@ceu.ox.ac.uk>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Re: Cannot get date fields to import from PostgreSQL via ODBC
Date   Wed, 28 Sep 2005 10:10:23 +0100

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Well, I found out something rather interesting related to this.

Dates, times and date/time-stamps do not import correctly via ODBC from
a PostgreSQL database;

However, with a MySQL database, although times and date/time-stamps do
not import correctly, plain dates *do* import correctly.

/me goes off to investigate the odbc-postgresql driver.

Dave.
- -- 
Dave Ewart
davee@ceu.ox.ac.uk
Computing Manager, Cancer Epidemiology Unit
Cancer Research UK / Oxford University
PGP: CC70 1883 BD92 E665 B840 118B 6E94 2CFD 694D E370
Get key from http://www.ceu.ox.ac.uk/~davee/davee-ceu-ox-ac-uk.asc
N 51.7518, W 1.2016
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFDOl3/bpQs/WlN43ARAlRPAKC6jV+y/AJijE5/H9TjryXdmuM6GQCePC/I
7gTMiqWahpokD/AJYCDwWhQ=
=9bzb
-----END PGP SIGNATURE-----
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index