windows date

B. Verkerk wrote:
 > How can I convert a windows date stored in Mysql (ie 38397 for today) to something I can use in a where clause?

Here's an expression that converts the value 38397 to '2005-02-14'.
Does this do what you want?

mysql> SELECT FROM_DAYS( 38397 + TO_DAYS('1899-12-30') );
+--------------------------------------------+
| FROM_DAYS( 38397 + TO_DAYS('1899-12-30') ) |
+--------------------------------------------+
| 2005-02-14 |
+--------------------------------------------+
1 row in set (0.00 sec)

Regards,
Bill K.