Re: [AMaViS-user] Any good reason to use TIMESTAMP on time_iso?

2006-07-28 Thread Mark Martinec
Paolo, Is there a performance reason, future (un)support, cleaniness, ... to switch from time_iso char(16) NOT NULL, to time_iso TIMESTAMP NOT NULL DEFAULT 0, ?? I can't see a good reason, except for a more understandable DB maintenance query. Yes, that is one. The other is that

Re: [AMaViS-user] Any good reason to use TIMESTAMP on time_iso?

2006-07-05 Thread Paolo Cravero as2594
Gary V wrote: time_iso char(16) NOT NULL, vs. time_iso TIMESTAMP NOT NULL DEFAULT 0, My impression is (and I could be wrong) that msgs.time_iso was originally [...] or the other, and set up your scripts to use the one you choose to index. Thanks. Will give it a try. Let me start my

[AMaViS-user] Any good reason to use TIMESTAMP on time_iso?

2006-07-04 Thread Paolo Cravero as2594
Hi, I've read 2.4.2 docs and past messages, but found not a real answer. Is there a performance reason, future (un)support, cleaniness, ... to switch from time_iso char(16) NOT NULL, to time_iso TIMESTAMP NOT NULL DEFAULT 0, ?? I can't see a good reason, except for a more

Re: [AMaViS-user] Any good reason to use TIMESTAMP on time_iso?

2006-07-04 Thread Gary V
Paolo wrote: Hi, I've read 2.4.2 docs and past messages, but found not a real answer. Is there a performance reason, future (un)support, cleaniness, ... to switch from time_iso char(16) NOT NULL, to time_iso TIMESTAMP NOT NULL DEFAULT 0, ?? I can't see a good reason, except