Re: Timestamp records

2003-01-06 Thread ed
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

Re: Timestamp records

2003-01-06 Thread Roger Baklund
* [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

Timestamp records

2003-01-06 Thread ed
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

Re: How to timestamp records across time zones? ##

2002-03-11 Thread Keith C. Ivey
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

Re: How to timestamp records across time zones? ##

2002-03-11 Thread DL Neil
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

How to timestamp records across time zones? ##

2002-03-11 Thread BD
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