MySQL - Java date values

BizzyC

Hi,
trying to use java to insert data into a mysql database, but I one of the fields is a DATETIME object, and I dont know how to get java to generate this.

Can anyone tell me how to do this?

Cheers.

rsynnott

BizzyC wrote:

Hi,
trying to use java to insert data into a mysql database, but I one of the fields is a DATETIME object, and I dont know how to get java to generate this.

Can anyone tell me how to do this?

Cheers.

Assuming you're using a Date object, do "date.getTime()". This gives you the number of seconds since 1970. Then insert it using something like this: "INSERT INTO <table>(<datetime field>) VALUES(FROM_UNIXTIME(<result of above))" There are more graceful ways to do it, but that one will work provided you don't need to go before 1970, and means you don't have to mess with the horrible GregorianCalendar class.
Rob.

seamus

rsynnott wrote:

Assuming you're using a Date object, do "date.getTime()". This gives you the number of seconds since 1970; as far as I remember MySQL is willing to accept this as a proper date. If not, you may have to mess with the GregorianCalendar class.
Rob.

Yep. DATETIME types should accept a timestamp (System.currTimeMilis() * 1000) as a valid value.

Callan

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

will also work

rsynnott

Of course, if you want the CURRENT date/time, all you need to do is INSERT <blah, blah> VALUES(NOW())

(Always assuming that your MySQL server's clock is semi-accurate; was using a free MySQL DB service who's clock was SIX MONTHS wrong recently...)
Rob

BizzyC

Cheers guys.

Got it working.

comanche

should you not be using setTimeStamp?

tempest

comanche wrote:

should you not be using setTimeStamp?

Not for Statement objects. For Prepared or Callable Statements then yes,