-----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
[email protected]
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/
