Re: How to approach converting to CDBI?

[prev] [thread] [next] [Date index for 2005/07/04]

From: Michael Peters
Subject: Re: How to approach converting to CDBI?
Date: 16:18 on 04 Jul 2005


Mike Whitaker wrote:
> 
> On 4 Jul 2005, at 17:07, Michael Peters wrote:
> 
>>> Lastly, we have a lot of code that sets a timestamp to "now()".   Should
>>> I replace that with the perl-thought of current time?
>>>
>>
>> That's a hard one.
> 
> 
> Isn't that what the MySQL TIMESTAMP column type is for?

Well I didn't say that for a couple of reasons.

- The OP said he was using Postgres and I'm not as familiar with it as
MySQL so I didn't want to give a db specific answer.

- TIMESTAMPs are indiscriminant. The first one will change with each
update no matter what. What happens if you want a column that only
occasionally gets set to NOW()? For instance, what if you have a
'resolved' column in an issues database. You don't want it updated to
NOW() until the issue is finished and then never again.

        -- 
        Michael Peters
Developer
Plus Three, LP

How to approach converting to CDBI?
Brett Sanger 15:45 on 04 Jul 2005

Re: How to approach converting to CDBI?
Michael Peters 16:07 on 04 Jul 2005

Re: How to approach converting to CDBI?
Mike Whitaker 16:09 on 04 Jul 2005

Re: How to approach converting to CDBI?
Michael Peters 16:18 on 04 Jul 2005

Re: How to approach converting to CDBI?
Mike Whitaker 16:21 on 04 Jul 2005

Re: How to approach converting to CDBI?
Brett Sanger 16:28 on 04 Jul 2005

Re: How to approach converting to CDBI?
Brett Sanger 16:20 on 04 Jul 2005

Re: How to approach converting to CDBI?
Brett Sanger 17:56 on 04 Jul 2005

Re: How to approach converting to CDBI?
Matt S Trout 17:27 on 04 Jul 2005

Re: How to approach converting to CDBI?
Brett Sanger 17:36 on 04 Jul 2005

Re: How to approach converting to CDBI?
Jonathan Tweed 18:09 on 04 Jul 2005

Re: How to approach converting to CDBI?
Matt S Trout 18:40 on 04 Jul 2005

Re: How to approach converting to CDBI?
Tony Bowden 20:39 on 04 Jul 2005

Re: How to approach converting to CDBI?
Michael Peters 20:48 on 04 Jul 2005

Re: How to approach converting to CDBI?
Matt S Trout 21:49 on 04 Jul 2005