Results 1 to 2 of 2

Thread: Datetime Format

  1. #1
    Join Date
    Sep 2004
    Posts
    2

    Question Unanswered: Datetime Format

    Hi, i'm new in this forum
    I've a strange problem. I've a datetime field that doesn't come updated properly.

    With this code

    UPDATE table SET field = '2004-09-02 10:48:15' WHERE field2 = 1

    the new value of field is

    2004-09-02 15.__.__

    why ???!?

    p.s. : sorry for my english..i'm Italian

  2. #2
    Join Date
    Sep 2003
    Location
    So. Cal. USA
    Posts
    142
    Hi, M! I am new, too. The SQL looks okay to me, so that makes me suspect the field type or field configuration. Try submitting to TEXT/BLOB field instead to double-check and then create another datetime field and try again...

    UPDATE tablename SET fieldtextfield = '2004-09-02 10:48:15' WHERE field2 = 1

Posting Permissions

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