Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007

    Unanswered: database date time format

    2007-11-23 11:10:37.865588+08

    what is the meaning of behind part ".865588+08" ?
    and how to set it???

  2. #2
    Join Date
    Nov 2003
    Provided Answers: 8
    As those are microseconds I assume that this is simply the scientific notation for the number of microseconds.
    So you have .865588 * 10^8 microseconds which computes to 86558800.

    Check out the comments about microseconds in the manual
    Quote Originally Posted by manual
    The seconds field, including fractional parts, multiplied by 1 000 000. Note that this includes full seconds.

    Result: 28500000

  3. #3
    Join Date
    May 2005
    San Antonio, Texas
    from docs:

    TIMESTAMP '2004-10-19 10:23:54'

    is a timestamp without time zone, while

    TIMESTAMP '2004-10-19 10:23:54+02'

    is a timestamp with time zone. PostgreSQL never examines the content of a literal string before determining its type, and therefore will treat both of the above as timestamp without time zone. To ensure that a literal is treated as timestamp with time zone, give it the correct explicit type:

    TIMESTAMP WITH TIME ZONE '2004-10-19 10:23:54+02'
    Vi veri veniversum vivus vici
    By the power of truth, I, a living man, have conquered the universe

Posting Permissions

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