this could help http://www.mysql.com/doc/en/Date_and_time_functions.html
V!nay Chris W wrote: > Andy Prasetya wrote: > > > Hello, > > > > I'm a newbie in MySQL. I have a table that contains column 'startdate > > [date]' and 'enddate [date]'. Somehow, I have to execute SQL that > > search any entry that corresponds to the current year and current > > month, e.g.: > > > > "SELECT * FROM mytable WHERE fieldx = '123' AND (startdate LIKE > > '2004-01-%' || enddate LIKE '2004-01-%') ORDER BY id" > > > > This SQL works with any entry that has startdate like '2004-01-02' and > > enddate like '2004-01-30'. > > > > Now, how do I modify my SQL so I can also retrieve any entry that has > > startdate < '2004-01-%' and enddate > '2004-01-%' ? > > Just use startedate < '2004-01-01' and enddate > '2004-01-31' > > That will find anything with a start date before Jan of 2004 and an end > date after Jan of 2004. > > Chris W > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]