OLE Automation Date conversion

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

I have a database with many datetime columns that are stored as
floating point numbers that represent the number of days since Jan 01,
1900 - or I guess it's really since Jan 00, 1900.  This was done
because the datetime field in MySQL had a precision of only 1 second
and we needed fractional seconds - I'm not sure if this constraint is
still true.

Currently we don't have time to write any frontend applications to
query the database so I want to make it easier for people to filter
the data without having to convert to/from a number.

What I'm looking for is some type of MySQL conversion function to do
the following:

SELECT * FROM mytable WHERE timestamp > ConvertToNumber("2007/5/25
1:23 PM")

SELECT ConvertToDateTime(timestamp), someothercolumn, FROM mytable

The only related methods I could find where CAST() and CONVERT() but I
couldn't find any way to use them to produce the results I wanted.

Site Timeline