Results 1 to 2 of 2
  1. #1
    ironballs is offline Member
    Join Date
    Aug 2007
    Posts
    1
    Rep Power
    0

    Default Date as String to TimeStamp

    Hi,
    I'm trying to convert date & time presented in String to TimeStamp object (so it could be written to DB).
    I've created a small program to test this, but the problem is, that every time, when I check the resulting Timestamp object the date part always resets to '01' - it's the same thing when writtne to the DB:


    String t2,st = "16/08/2007 09:04:34";
    SimpleDateFormat sdf = new SimpleDateFormat("dd/mm/yyyy hh:mm:ss");
    Date date = sdf.parse(st);
    Timestamp timestamp = new Timestamp(date.getTime());
    t2 = timestamp.toString();
    // T2 will show: "2007-01-16 09:04:34.0"

    anyone knows how to solve this issue ?

    thanks.

  2. #2
    shanePreater is offline Member
    Join Date
    Jul 2007
    Location
    England, Bath
    Posts
    47
    Rep Power
    0

    Default

    change the first mm to MM as mm represents minutes not Month which is represented by MM
    :)

Similar Threads

  1. Difference between current date and anothe date
    By vijay balusamy in forum New To Java
    Replies: 1
    Last Post: 04-16-2008, 04:15 PM
  2. Timestamp in SQL format
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 02-10-2008, 11:37 AM
  3. Converting Epoch to string Date
    By amyedwards in forum New To Java
    Replies: 3
    Last Post: 12-14-2007, 10:33 PM
  4. Replies: 0
    Last Post: 11-20-2007, 04:59 PM
  5. String to Date conversion
    By javaplus in forum New To Java
    Replies: 2
    Last Post: 11-06-2007, 07:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •