Discussions

General J2EE: Inserting java.sql.Date type variable to database

Bookmark and Share Get thread feed

  1. Inserting java.sql.Date type variable to database (4 messages)

    • Posted by: Hyson Mathew
    • Posted on: November 27 2005 23:56 EST
    Hi to all,
    I have a PostgreSql database table which contains field of type date .I want to insert the date in the format of “dd-MMM-YYYY”. I am using the preparedStatement to insert the date field as well as other fields to the table.Please help me.
    Regards,
     Hyson
    Reply to this

    Threaded Messages (4)

  2. Inserting java.sql.Date type variable to database[ Go to top ]

    you can insert the date as

    pstmt.setDate(new java.util.Date(person.getBirthDate().getTime()));

    where, person is a reference to a class Person.
    The date will be inserted in yyyy-mm-dd format.

    you can use the sql date formatting options for outputting it the way u like
    Reply to this Reply to original

  3. Problem whileInserting java.sql.Date type variable to database[ Go to top ]

    Thanks umar ali for your reply and help. I have tried that way but there is no date formating functions are avail for the class java.sql.Date which are compactable with the pst.setDate() method (where pst is the reference to the type java.sql.PreparedStatement).The pstmt.setDate(1,date) method only accept java.sql.Date type arguments.So I didn’t got the expected result
    Reply to this Reply to original

  4. Problem whileInserting java.sql.Date type variable to database[ Go to top ]

    The date formatting functions are not in java.sql. package but your database vendors provide the formatting functions for outputting the date. For ex.

    SELECT BIRTHDATE(TO_DATE("DD-MM-YYYY")) FROM USER;

    Check ur database vendor manual for details
    Reply to this Reply to original

  5. thanks[ Go to top ]

    thanks for your reply .I will try
    Reply to this Reply to original