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:hadi.rast...@gmail.com] 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 <a.shab...@egyptnetwork.com<mailto:a.shab...@egyptnetwork.com>> wrote: Did you tried that before -------------------------------------------------------------------------- _ _ _ __ _ _ /_\ | |__ _ __ ___ ___ __| | / _\ |__ __ _| |__ __ _ _ __ __ _ //_\\| '_ \| '_ ` _ \ / _ \/ _` | \ \| '_ \ / _` | '_ \ / _` | '_ \ / _` | / _ \ | | | | | | | | __/ (_| | _\ \ | | | (_| | |_) | (_| | | | | (_| | \_/ \_/_| |_|_| |_| |_|\___|\__,_| \__/_| |_|\__,_|_.__/ \__,_|_| |_|\__,_| From: Sayed Hadi Rastgou Haghi [mailto:hadi.rast...@gmail.com<mailto:hadi.rast...@gmail.com>] 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 <a.shab...@egyptnetwork.com<mailto:a.shab...@egyptnetwork.com>> 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 e...@egyptnetwork.com<mailto:e...@egyptnetwork.com> Meet us at: [cid:image001.jpg@01CBF7B5.6A6BC4E0]<mailto:sa...@egyptnetwork.com?subject=Gitex%20KSA%202011%20-%20Meeting%20Request> -- Sincerely, Sayed Hadi Rastgou Haghi -- Sincerely, Sayed Hadi Rastgou Haghi
<<inline: image001.jpg>>