Results 1 to 3 of 3

Thread: TIMESTAMP long format

  1. 05-05-2005, 08:30 AM #1
    aneto
    aneto is offline Registered User
    Join Date
    Apr 2005
    Posts
    16

    TIMESTAMP long format

    Hi there,

    I have a BIGINT field where I want to store a unique value so I want to use a TIMESTAMP value but using UNIX_TIMESTAMP() I don't get the long format time (TIMESTAMP(14)), I just get values like "1115288781" and I need something like "1114608169497".

    Any ideas?

    Thanks!
    Reply With Quote Reply With Quote
  2. 05-05-2005, 08:41 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    what RDBMS?
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 05-05-2005, 08:44 AM #3
    aneto
    aneto is offline Registered User
    Join Date
    Apr 2005
    Posts
    16
    Sorry, I forgot to tell is MySql.

    Thanks!
    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