[Babase] Using Datetime columns after all

Catherine Markham (amarkham at Princeton.EDU) amarkham at Princeton.EDU
Sun Nov 20 09:14:41 EST 2005


Hi all,

I remember asking Karl about date/time columns in general when I first started working with the weather data.  We already had a date column, but we wanted to add the time as well - I was asking whether this could be a separate column or had to be together in one date/time field.  I'm still not entirely sure from Karl's email what the answer is, but my preference would be the data separated in 2 columns (which is the way I have it now).  

As for the date/time info from Psion, I always had the impression that Psion data were analyzed by considering that each consecutive sample is 1 minute from the last sample - regardless of the details of the date/time stamp associated with each reading.  Of course that's definitely something to check with Susan, but the I thought the date/time just reflected when the team got the data entered in Psion and was not necessarily associated with the exact time of the observation.  I think if you look closely at the time intervals between samples, you'll see they certainly aren't always 60 seconds apart (as I think the protocol says they should be).

But (here comes my disclaimer...) that's just based on my impression after glancing through the Psion related tables - I've never really looked at it in more detail beyond that.

Catherine


----- Original Message -----
From: "Karl O. Pinc" <kop at meme.com>
Date: Sunday, November 20, 2005 3:28 am
Subject: [Babase] Using Datetime columns after all
To: babase at eeblistserv.Princeton.EDU

> Well, now that I've gotten deep into looking at the
> interaction data I find that the Datetime columns
> contain the most accurate and detailed information,
> stuff that wouldn't otherwise fit into the existing
> foxpro columns.  I don't remember exactly what
> Cathrine was wanting to do regarding the Datetime
> columns but I hope she either hasn't done it or
> can undo it, or whatever was done did not affect
> the time information, which is mostly what's important
> in there, or did not affect the rows with Sids, which are the ones
> with the extra data.  If she did do something I'll
> need to know exactly what so I can get the right
> data moved over in the conversion.
> 
> If I'm even remembering right about her wanting
> to do something.  It's kinda late.
> 
> This is what we get for not documenting.
> 
> Let me know what the status is.
> 
> 
> Karl <kop at meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
> 
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase
> 


More information about the Babase mailing list