how to convert yyyy-MM-dd HH:mm:ss to java.sql.Date

Discussion in 'Java' started by sh, Mar 2, 2007.

  1. sh

    sh Guest

    hi,

    how to convert date in this format yyyy-MM-dd HH:mm:ss to
    java.sql.Date



    if i use directly like this java.sql.Date.valueOf(processDate)

    am getting exception java.lang.NumberFormatException: For input
    string: "02 19:51:51"


    if anybody knows reply back immedietely.

    thanks in advance
    sh, Mar 2, 2007
    #1
    1. Advertising

  2. sh

    www Guest

    sh wrote:
    > hi,
    >
    > how to convert date in this format yyyy-MM-dd HH:mm:ss to
    > java.sql.Date
    >
    >
    >
    > if i use directly like this java.sql.Date.valueOf(processDate)
    >
    > am getting exception java.lang.NumberFormatException: For input
    > string: "02 19:51:51"




    SimpleDateFormat myFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    Date myDate = new Date(myFormat.parse(your_time_string).getTime());
    //need try-catch block

    BWY, why you input "02 19:51:51"? It should be "2002-xx-xx 19:51:51",
    based on your SimpleDateFormat.
    www, Mar 2, 2007
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Totto
    Replies:
    5
    Views:
    900
    Cowboy \(Gregory A. Beamer\)
    Aug 25, 2006
  2. Ashraf Ansari

    convert MM/dd/yyyy format into dd/MM/yyyy

    Ashraf Ansari, Aug 30, 2007, in forum: ASP .Net
    Replies:
    4
    Views:
    780
    Alexey Smirnov
    Aug 30, 2007
  3. Replies:
    5
    Views:
    5,584
  4. Gilles Ganault

    Converting DD MM YYYY into YYYY-MM-DD?

    Gilles Ganault, Aug 17, 2009, in forum: Python
    Replies:
    18
    Views:
    1,332
    Mark Tolonen
    Aug 20, 2009
  5. J P Singh
    Replies:
    4
    Views:
    274
    J P Singh
    Feb 10, 2004
Loading...

Share This Page