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

st: ODBC date/time query


From   "Joley, Chris" <CJoley@uta.cog.ut.us>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: ODBC date/time query
Date   Wed, 30 Jul 2003 14:44:05 -0600

Hello all,

I am attempting to import data via the ODBC command.  All of the
variables import fine except a date/time variable.  The variable is in
the format [mm/dd/yyyy hh:mm AM] When I load the data in Stata all I get
is the date information, not the time.  For some reason it truncates and
assigns it the %td format.  When I query the same database in MS Access
I get the complete date and time.  Why doesn't Stata pull all the data
from the field when it imports?  Any suggestions?   Thanks.

 

Chris



*
*   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