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

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


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

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

On Friday, 23.09.2005 at 15:51 +0100, Dave Ewart wrote:

> . odbc load, exec("select * from mytable")
> 
> . list
> 
>      +----------------------------------+
>      |         a          b           c |
>      |----------------------------------|
>   1. | 01jan1960   10:20:30   01jan1960 |
>      +----------------------------------+

I should have added that doing a 'direct' ODBC query using the
command-line client 'isql' returns good data:

$ isql pgstuff
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select * from mytable;
+-----------+---------+---------------------------+
| a         | b       | c                         |
+-----------+---------+---------------------------+
| 2005-09-23| 10:20:30| 2004-01-01 19:27:03       |
+-----------+---------+---------------------------+
1 rows affected
1 rows returned

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)

iD8DBQFDNBgWbpQs/WlN43ARApIfAJ4pAZgokkq7DnEzqYP70xN5h/Uf8QCeI8sg
KlQLk6zsc3ACvnNhiwYvLXo=
=BRzp
-----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