[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