Yes I tried it and it gives me the format that you mentioned below But really most of its values are some thing like this '0000-00-00 00:00:00' ?
From: Sayed Hadi Rastgou Haghi [mailto:[email protected]] Sent: Sunday, April 10, 2011 7:28 PM To: Ahmed Shabana Subject: Re: Rotate DLR table yes a timestamp = date in seconds and you can use queries like ts >= "2011-01-01 00:00:00" and mysql handles it. On Sun, Apr 10, 2011 at 9:38 PM, Ahmed Shabana <[email protected]<mailto:[email protected]>> wrote: Did you tried that before -------------------------------------------------------------------------- _ _ _ __ _ _ /_\ | |__ _ __ ___ ___ __| | / _\ |__ __ _| |__ __ _ _ __ __ _ //_\\| '_ \| '_ ` _ \ / _ \/ _` | \ \| '_ \ / _` | '_ \ / _` | '_ \ / _` | / _ \ | | | | | | | | __/ (_| | _\ \ | | | (_| | |_) | (_| | | | | (_| | \_/ \_/_| |_|_| |_| |_|\___|\__,_| \__/_| |_|\__,_|_.__/ \__,_|_| |_|\__,_| From: Sayed Hadi Rastgou Haghi [mailto:[email protected]<mailto:[email protected]>] Sent: Sunday, April 10, 2011 6:42 PM To: Ahmed Shabana Subject: Re: Rotate DLR table please change it to timestamp. Some other fields need a review too. On Sun, Apr 10, 2011 at 8:00 PM, Ahmed Shabana <[email protected]<mailto:[email protected]>> wrote: Hi all As day after day the DLR table size grow ,I want to make simple script that rotate the dlr table based on ts field But I really have not idea about its format , It just a varchar(100) field ,and I have no idea about its format Do u have any idea about this field format Best Regards, Ahmed Shabana | System Engineer | Creative Communication Solutions Egypt M +20 (10) 3325373 | Tel +20 (50) 2528897 Saudi M + 966 (54) 8065712 | Tel +966 (1) 4040638 MSN [email protected]<mailto:[email protected]> Meet us at: [cid:[email protected]]<mailto:[email protected]?subject=Gitex%20KSA%202011%20-%20Meeting%20Request> -- Sincerely, Sayed Hadi Rastgou Haghi -- Sincerely, Sayed Hadi Rastgou Haghi
<<inline: image001.jpg>>
