Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #103

Re: timestamp and time zone

Show all headers | View raw

On 2011-04-30, Jasen Betts <jasen@xnet.co.nz> wrote:

> timestamp is internally stored with no zone translation so 
> '2011-04-30 23:02:39.296282' will look the same whatever 
> the user uses for their timezone. (different datestyle
> settings can effect the date part however)

It is again stored internally as a number. 

 As I understand it: this number is the difference in 
milliseconds between "1970-01-01 00:00:00" and the time
given, for this computation both times are expressed in 
a region that does not do daylight saving or leap seconds 
(eg: UTC).  Most linux systems use a 64 bit integer, but
some oddball ones may use a 64 bit floating point number
instead.


-- 
⚂⚃ 100% natural

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

timestamp and time zone "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2011-04-28 18:00 +0200
  Re: timestamp and time zone Dog is love <michaelnewportyahoo.com@gmail.com> - 2011-04-28 10:05 -0700
    Re: timestamp and time zone "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2011-04-28 19:22 +0200
  Re: timestamp and time zone Harry Tuttle <OTPXDAJCSJVU@spammotel.com> - 2011-04-29 08:45 +0200
    Re: timestamp and time zone "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2011-04-29 12:23 +0200
      Re: timestamp and time zone D Yuniskis <not.going.to.be@seen.com> - 2011-04-29 06:02 -0700
  Re: timestamp and time zone Jasen Betts <jasen@xnet.co.nz> - 2011-04-30 11:15 +0000
    Re: timestamp and time zone Jasen Betts <jasen@xnet.co.nz> - 2011-04-30 11:26 +0000
    Re: timestamp and time zone "M. Strobel" <sorry_no_mail_here@nowhere.dee> - 2011-04-30 17:58 +0200
      Re: timestamp and time zone Jasen Betts <jasen@xnet.co.nz> - 2011-05-01 11:33 +0000

csiph-web