Monday, November 29, 2010

Comparing date with any mysql column

You can easily compare dates at SELECT query from mysql.

Using the function, just convert your date into appropriate one. For example using CAST('2010-10-18' as DATE) at select query.

SELECT * from my_table WHERE date_column < CAST('2010-10-18' as DATE)

You can use the date '2010-10-18' from a variable too.

1 comment:

A. Retha said...

This works fine for me without the need to cast. I just put a string date link '2011-02-11' in the query and it just works.

Get function name programaticaly - Python

This little piece of code will help you to get the function name programatically. This is very helpful when you are implementing the debug...