Trying to convert Java Date to type int to fit in mysql table with field type int(11)

[fortwnty420]

I am trying to convert a date such as "dd-MM-yyy" "01/01/2011" to a type int(11) for a mysql database.

The only thing I can find is a conversion to long using the Date class and the simple date formatter.

.getDate is deprecated and only .getTime is available. (which returns type long). If I just cast it from a long to an int I totally lose the date.

Any help would be greatly appreciated.

Jeff-

[fortwnty420]

This worked for me: The trick was to divide the long value by 1000 and this makes it small enough for an int.

private java.util.Date end_date(String str_end_date ){

DateFormat formatter;

java.util.Date end_date = new java.util.Date();

try{

formatter = new SimpleDateFormat("MM-dd-yyyy");

end_date = (java.util.Date)formatter.parse(str_end_date);

VMProductDiscountsDataBag dtl = new VMProductDiscountsDataBag();
dtl = this.arrDataBag.get(this.DetailIndex);
dtl.end_date = Long.valueOf(end_date.getTime()/1000).intValue();
dtl.IsDirty = true;
arrDataBag.set(this.DetailIndex, dtl);

}
catch (ParseException e){
System.out.println("Exception :"+e);
}

return end_date;

}

[DarrylBurke]

If you're only concerned with the date and not the time-of-day, you can divide by (1000 * 60 * 60 * 24), or format and store it in ANSI date format (YYYYMMdd). But why on earth do you have an int(11) column for a date value in the first place? MySQL provides 3 data types (granted that one of them has the y2k38 bug).

db

[fortwnty420]

I didn't choose the design actually.. It is for virtue_mart. that is the table structure that the system uses.. I was only concerned with the actual date..

Thanks for you help it is much appreciated!

Jeff-

[Tolls]

What does that int(11) represent?
Can't really do any conversion without knowing what it is supposed to be...