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

    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,
    Swapna

  2. #2
    Join Date
    Jul 2004
    Location
    Dundee, Scotland
    Posts
    107
    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?

    http://dev.mysql.com/doc/mysql/en/TIME.html

    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
  •