Skip to main content

Search

Items tagged with: timestamps


 

Timestamps and Time Zones in PostgreSQL


The nuance between timestamp with and without time zone

HN Discussion: https://news.ycombinator.com/item?id=19532090
Posted by GordonS (karma: 5664)
Post stats: Points: 117 - Comments: 42 - 2019-03-30T21:47:37Z

#HackerNews #and #postgresql #time #timestamps #zones
Article content:

... show more


 
Solving the Year 2038 problem in the Linux kernel....Because of the way time is represented in Linux,a signed 32-bit number can't support times beyond January 19,2038 after 3:14:07 UTC.This Year 2038 (Y2038 or Y2K38) problem is about the time data type representation.The solution is to use 64-bit timestamps.
#Linux #kernel #Y2038 #Y2K38 #timestamps #32-bit #64-bit #computer #software #FOSS #TECHNOLOGY
https://opensource.com/article/19/1/year2038-problem-linux-kernel?utm_medium=Email&utm_campaign=weekly&sc_cid=701f2000000RRDQAA4&elqTrackId=6c76af4fadfc47f8b484e719373b3fc3&elq=fe81b78e0ddc4dea83d367ae077c71aa&elqaid=59079&elqat=1&elqCampaignId=186821