Skip to content

handling dates

7 messages · Strumila, John, Faheem Mitha, Thomas Lumley +4 more

Strumila, John
# 
howdy R friends,

Can anyone help me with converting a 'unix' date (seconds since 1970) into
something readable?

There doesn't seem to be anything in the 'date' package and the prospect of
calculating this myself doesn't excite me.

thanks,
John Strumila
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Faheem Mitha
# 
Dear John,

If you are using Unix look at man date or, preferably, info date (which is
more comprehensive, and has examples). I think you may be able to do your
conversion using the tools they have available, though I couldn't see how
immediately. If you aren't using Unix, you should be :-). Or give me an
example of what you want converted, and I will try and get it to work.

Personally, I enjoy fiddling around with Unix, but each to his own
perversion...
                                                 Faheem.
On Mon, 22 May 2000, Strumila, John wrote:

            

      
      
      
    

        
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

  
  


  


      

    

    

      
      

        


  

        

      Thomas Lumley
    

    

      
      #
    

  


  

      
On Mon, 22 May 2000, Strumila, John wrote:

        

            

      
      
      
    

        
Well, if you take a date and divide by 60*60*24 you have days since the
zero date. You can then add this to the zero date.  

   date<-mdy.date(1,1,1970)+unixdate/(60*60*24)


	-thomas


Thomas Lumley
Assistant Professor, Biostatistics
University of Washington, Seattle

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

  
  


  


      

    

    

      
      

        


  

        

      dandon@capa.stat.umu.se
    

    

      
      #
    

  


  

      
Hi R users!
Is there any library for reading database file (dbf), or are there now
people working around with that?

Danar.


-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

  
  


  


      

    

    

      
      

        


  

        

      Torsten Hothorn
    

    

      
      #
    

  


  

      
On Tue, 23 May 2000 dandon at capa.stat.umu.se wrote:

        

            

      
      
      
    

        
Directly reading of *.dbf is not available (at my knowledge). You can read
your data into a database like Postgres, MySQL or mSQL and then use the
database packages RmSQL (CRAN) or RS_DBI (omegahat.org, I think) for
reading your data into the R paradise :-)

Torsten

            

      
      
      
    

        
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

  
  


  


      

    

    

      
      

        


  

        

      Jonathan.Yuen@evp.slu.se
    

    

      
      #
    

  


  

      
Hello All,

I use dbf2txt (a perl script written by Gilbert Ramirez at University of
Texas) to convert dbase files to text files.  It also will produce the
necessary program (for another statistical package produced by a company
in North Carolina) to read the text file if you give it the -s option.  
Might be a good place to start, at least to see how the dbase file is
constructed.

Jonathan

Jonathan Yuen, Professor in Plant Pathology     phone: 46 18 672369
Dept. of Ecology and Crop Production Sciences   fax:   46 18 672890
Swedish University of Agricultural Sciences     http://www.tvs.slu.se
Box 7043                                        email replies to
S 750 07 Uppsala, SWEDEN                        Jonathan.Yuen at evp.slu.se 


-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

  
  


  


      

    

    

      
      

        


  

        

      A.J. Rossini
    

    

      
      #
    

  


  

          

      
      
      
    

        
d> Hi R users!  Is there any library for reading database file
    d> (dbf), or are there now people working around with that?

Debian has a number of conversion utilites,
dbfto(NAME_AN_OPENSOURCE_SQL_DB), as well as general tools for
extracting information into tab/csv formats.

You might look there and backtrace to find the actual source.