Insert the current date

[Rajkumar balakrishnan]

Hi friends,
I need to insert the current date in the MySQL table and when i try to do so a compilation error occurs..

: Edited :

[Rene Larsen]

You need to insert a 'java.sql.Date' into 'ps.setDate(1, ...)'

[Rajkumar balakrishnan]

Originally posted by Rene Larsen:
You need to insert a 'java.sql.Date' into 'ps.setDate(1, ...)'

I want to insert the current date into table, but i don't know how to accomplish that.. Please post me some code here..I am in :roll:
Please help me..........

[Shailesh Chandra]

Originally posted by Rajkumar balakrishnan:


I want to insert the current date into table, but i don't know how to accomplish that.. Please post me some code here..I am in
Please help me..........

ps.setDate(1,new java.sql.Date(System.currentTimeMillis()));

Thanks,
Shailesh

[Rajkumar balakrishnan]

Originally posted by Shailesh Chandra:

ps.setDate(1,new java.sql.Date(System.currentTimeMillis()));

Thanks,
Shailesh

Thanks for that... And now a silly question is this one stores the time in milliseconds where i need it to be stored in yyyy-MM-dd format so that i can able to view it in reports.... Please help me regards this

[Rene Larsen]

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Date;
 
public class Test {
 
    public static void main(String[] args) {
        Date currentDatetime = new Date(System.currentTimeMillis());
        java.sql.Date sqlDate = new java.sql.Date(currentDatetime.getTime());
        java.sql.Timestamp timestamp = new java.sql.Timestamp(currentDatetime.getTime());
 
        Connection conn = null;
        PreparedStatement statement = null;
 
        try {
            conn = null; // get a Connection from somewhere...
            statement = conn.prepareStatement("insert into some_table(id, startdate) values (?,?)");
            statement.setLong(1, 1);
 
            statement.setDate(2, sqlDate); // will insert only the date
            /* or */
            statement.setTimestamp(2, timestamp);// will insert both the date and time
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                if (statement != null) {
                    statement.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException e) {
                /* ignore */
            }
        }
    }
}

[Rene Larsen]

Originally posted by Rajkumar balakrishnan:


Thanks for that... And now a silly question is this one stores the time in milliseconds where i need it to be stored in yyyy-MM-dd format so that i can able to view it in reports.... Please help me regards this

If you need to show the date in a special format, you need to use SimpleDateFormat to format the date/timestamp returned fra the database.

[Rajkumar balakrishnan]

Originally posted by Rene Larsen:


If you need to show the date in a special format, you need to use SimpleDateFormat to format the date/timestamp returned fra the database.

Is there anyway to store the current date in the specified format...???

[Rene Larsen]

Originally posted by Rajkumar balakrishnan:


Is there anyway to store the current date in the specified format...???

Yes as a String (varchar).

[Rajkumar balakrishnan]

: Edited :

[Rene Larsen]

To be able to store the date as a String (varchar) in the database, you need to verify that the data type for the 'date' field is a varchar - or you have to change it from date/timestamp to varchar.

Here is how you put a Date as a String into the database:

SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd");
Date date = new Date(System.currentTimeMillis());
....
....
ps.setString(1, sdf.format(date));

[Rajkumar balakrishnan]

Originally posted by Rene Larsen:
To be able to store the date as a String (varchar) in the database, you need to verify that the data type for the 'date' field is a varchar - or you have to change it from date/timestamp to varchar.

Here is how you put a Date as a String into the database:

SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd");
Date date = new Date(System.currentTimeMillis());
....
....
ps.setString(1, sdf.format(date));

I dont want to change the field from date to varchar or something else.. So please help me inserting the current date with the required formatting....

[Shailesh Chandra]

Originally posted by Rajkumar balakrishnan:

I don't want to change the field from date to varchar or something else..

You should not! a date field should be of date type only in database

So please help me inserting the current date with the required formatting....

Why are you so specific about format, A date is stored in database as Date object not with its format. A format is only representation of date as string.

I suggest let the date be stored as Date and if you want to display same in a specific format is as Rene has suggested above. That would be an ideal approach.

Thanks,
Shailesh

[Rajkumar balakrishnan]

Originally posted by Shailesh Chandra:


Why are you so specific about format, A date is stored in database as Date object not with its format. A format is only representation of date as string.

I suggest let the date be stored as Date and if you want to display same in a specific format is as Rene has suggested above. That would be an ideal approach.

Thanks,
Shailesh

I have done it by the instructions given by the Rene..... Thanks ranchers for helping me...



Real life-savers.....