Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Unanswered: millisec support in MYSQL

    Hi all,

    I would like to know if there is millisec support in MySql. I am new to mysql and I was asked to find about this.

    Thanks a lot,

  2. #2
    Join Date
    Jul 2004
    Dundee, Scotland
    In short I'd say no.

    Are we talking about say storing millisec from PHP in a MySQL integer field? Or are we talking about manipulating millisec using MySQL functions?

    You can use the following "relaxed'' syntax: 'HH:MMS.fraction'. Note that MySQL doesn't yet store the fraction part.

    mysql> SELECT EXTRACT(MICROSECOND FROM '2003-01-02 10:30:00.00123');
    -> 123

    EXTRACT() was added in MySQL 3.23.0.

Posting Permissions

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