getting today's date

[marys joseph]

Hi,

I need to get today's date and insert into sql table.

Date d = new Date();
long today = now.getTime();

when I insert this value into sql table hour:min:sec is also inserted. please give me suggestions to get today's date in long value or in timestamp value without hr:min:sec attached to it.

thanks,

[clio katz]

if you're dealing with sql and java 1.4+, it will probably be helpful for you to review the java.sql and javax.sql API's right off

e.g.

    java.sql.Date dtSql = new java.sql.Date(System.currentTimeMillis());
    System.out.println("Date in JDBC escape format = " + dtSql.toString()); 

if you don't have these packages, you can use milliseconds or Calendar class to construct a SQL DATE in the desired format.

hth!

[somkiat puisungnoen]

If you want to use TimeStamp

Example code

 
   java.sql.TimeStamp time = new java.sql.TimeStamp(System.currentTimeMillis());