Thanks,
Ed
On Mon, 6 Jan 2003, Roger Baklund wrote:
> * [EMAIL PROTECTED]
> > I have a table of records using timestamp(14) as a field and need to
> > remove any records that are 60 days past the timestamp. I've looked at the
> > manual and can't find anything relating on doing this. What qu
* [EMAIL PROTECTED]
> I have a table of records using timestamp(14) as a field and need to
> remove any records that are 60 days past the timestamp. I've looked at the
> manual and can't find anything relating on doing this. What query would I
> need to run on the database?
To remove records, use
I have a table of records using timestamp(14) as a field and need to
remove any records that are 60 days past the timestamp. I've looked at the
manual and can't find anything relating on doing this. What query would I
need to run on the database?
TIA
Ed
mysql
Two more possibilities:
1. Set your MySQL server to use GMT for everything (that is, in the
OS, not in MySQL).
2. Store all times as Unix time (seconds since 1970) -- the
UNIX_TIMESTAMP() function can be useful for this.
Either solution still has the problem of converting to another forma
Brent,
> What's the best way to timestamp records if records are to be exported
and
> then re-imported to another web server in a different time zone? Data
will
> be exported as comma delimited data. All of the combined records
should
> reflect the same instant in time, and
What's the best way to timestamp records if records are to be exported and
then re-imported to another web server in a different time zone? Data will
be exported as comma delimited data. All of the combined records should
reflect the same instant in time, and not have the web si