Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2010
    Posts
    15

    Unanswered: Problem to update

    Hi,
    Any advice to this error?
    Code:
    17:08:24	update package set sms_time = STR_TO_DATE('1/4/2015 15:30:00','%d/%m/%Y %h:%i:%s') where id = 640725	0 row(s) affected, 1 warning(s): 1411 Incorrect datetime value: '1/4/2015 15:30:00' for function str_to_time Rows matched: 1  Changed: 0  Warnings: 0	0.000 sec
    Many Thanks & Best Regards,
    HuaMin Chen

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    use the ISO date format YYYMMDD
    or
    yyyy-mm-dd hh:mm:ss
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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