This one time, at band camp, Peter Giesin said:
PG>Is it currently possible to perform a OQL query on a timestamp column, but
PG>only examine the date and disregard the time? Or would I be better of using
PG>a separate date and time column. I am using MySQL.
Peter,
If this code will ever have a requirement of being run with databases
other than MySQL (I'm guessing not, though because of the specific
mention of timestamp), I would recommend performing date handling
programmatically and using a data type of char. But if MySQL is the
only database that will ever be used, I would recommend splitting
the colums in the datbase schema.
Bruce
--
perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
