Results 1 to 4 of 4

Thread: MySQL datetime problem

  1. Jul 13th, 2006, 03:00 PM #1
    PlayKid
    PlayKid is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Sep 2004
    Posts
    484

    MySQL datetime problem

    Hi all,

    I am trying to use the SQL statement below
    INSERT INTO (mytime)
    VALUES('14 July 2006')

    it doesn't work, it's complaining about my date is incorrect, can anyone help?

    Regards

    PlayKid
    Reply With Quote Reply With Quote
  2. Jul 14th, 2006, 05:28 AM #2
    ganeshmoorthy
    ganeshmoorthy is offline
    VB Guru ganeshmoorthy's Avatar
    Join Date
    Dec 2005
    Location
    Sharjah, United Arab Emirates
    Posts
    3,031

    Re: MySQL datetime problem

    where you have mentioned your table name in the query. mytime is your field name right...
    If an answer to your question has been helpful, then please, Rate it!

    Have done Projects in Access and Member management systems using BioMetric devices, Smart cards and BarCodes.

    Reply With Quote Reply With Quote
  3. Jul 14th, 2006, 06:33 AM #3
    salvelinus
    salvelinus is offline
    Frenzied Member
    Join Date
    Feb 2003
    Location
    Argentina
    Posts
    1,950

    Re: MySQL datetime problem

    MySql date format is yyyy/mm/dd. Try '2006/07/14'.
    Tengo mas preguntas que contestas
    Reply With Quote Reply With Quote
  4. Jul 15th, 2006, 05:41 AM #4
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: MySQL datetime problem

    YYYY-MM-DD will also work, and is somewhat common to many relevant databases. (Where relevant databases imply either SQL Server and MySQL. Others unknown)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width