windows date

[B. Verkerk]

How can I convert a windows date stored in Mysql (ie 38397 for today) to something I can use in a where clause?

Thnaks,

Bart

[Bill Karwin]

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.

[B. Verkerk]

thanks!

"Bill Karwin" <bi**@karwin.com> schreef in bericht news:cu*********@enews4.newsguy.com...

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.