SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast omid020's Avatar
    Join Date
    Feb 2008
    Posts
    66
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    help me on this error: #1264 Out of range value ...

    I have a "datetime" field and use my native calendar format to store data in it .
    I`m using jalali calendar . when I add 1388-04-30 00:00:00 database accept it but when I add 1388-04-31 00:00:00 in phpMyadmin I receive this error :
    Affected rows: 0
    Warning: #1264 Out of range value adjusted for column 'orderDate' at row 1
    How could I solve it?
    I`m using mysql 5.0.51 ...

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,250
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    mysql supports only one calendar, and 04-31 is not vald
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Enthusiast omid020's Avatar
    Join Date
    Feb 2008
    Posts
    66
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wow, what should I do now?
    I have defined "datetime" field type in all of my project tables;
    MySQL should have a logical solution for other countries date types; hasn`t it?


Bookmarks

Posting Permissions

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