#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2009
    Posts
    66
    Rep Power
    6

    Is it posible timestamp column to store seconds


    hello

    i want ot ask is it possible timestamp field to store seconds ?
    like this 2010-11-10 15:50:11
    i use firebird 1.5
    when i try to insert value 2010-11-10 15:50:11 it cuts the seconds and stores 2010-11-10 15:50

    please help
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2006
    Location
    Carlsbad, CA
    Posts
    2,057
    Rep Power
    383
    Originally Posted by JoseMourinho
    hello

    i want ot ask is it possible timestamp field to store seconds ?
    like this 2010-11-10 15:50:11
    i use firebird 1.5
    when i try to insert value 2010-11-10 15:50:11 it cuts the seconds and stores 2010-11-10 15:50

    please help
    TIMESTAMP fields store down to fractions of a second.

    Make sure that your problem is not just the way your GUI is displaying the values.

IMN logo majestic logo threadwatch logo seochat tools logo