July 17th, 2006, 04:36 PM
|
 |
I lov C in AIX/Linux, hate C++
|
|
Join Date: Jul 2003
Location: Jacksonville, Florida
Posts: 1,497
Time spent in forums: 1 Week 2 Days 16 h 56 m 32 sec
Reputation Power: 8
|
|
|
Some rows won't be deleted when using the DATE() in TIMESTAMP column.
I noticed that some rows won't be deleted if I use this SQL Query...
Code:
DELETE FROM INQUIRIES WHERE DATE(INQ_TIMESTAMP) < '2005-01-01'
THe INQ_TIMESTAMP use data-type of TIMESTAMP. So, why can't it be deleted?
Edited: Whoops!! Found hte curlpit of the problem. Found a code that use "(date('Y')-1).'-01-01'", I was thinking of something else at that time. Sorry!!
Last edited by fletchsod : July 18th, 2006 at 09:00 AM.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
