Do you have a question? Post it now! No Registration Necessary. Now with pictures!
May 25, 2007, 1:26 pm
rate this thread
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
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
SELECT * FROM mytable WHERE timestamp > ConvertToNumber("2007/5/25
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.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum