1 Reply Latest reply on Mar 17, 2004 3:51 AM by Alexey Loubyansky

    JBoss 3.x with MySQL and date fields as Long/Integer?

    davout Newbie

      I'm using EJB CMP in my first JBoss project against a MySQL database.

      As standard EQL cannot employ DATE types as part of its query am I right in thinking that I should be storing my dates as Long values? that way I use standard numeric operands to enable EQL retrievals, right?

      I can use the 'Calendar.getTimeInMillis' to find the date 'Long' value and then store this to the MySQL table.

      By the way is a Java 'Long' equivalent to a MySQL 'Integer'?