Stack Overflow
Stack Overflow

Questions tagged [timestamp-with-timezone]

A datetime (timestamp in SQL) that is time zone aware, usually by storing time zone information along with the datetime. Data type defined in the SQL standard.

A ( in ) that is aware, usually by storing time zone information along with the datetime.

defined in .

Note that , different from most other s, stores this data type as timestamp in , so that time zone information is not preserved upon retrieval.

496 questions
5
votes
1 answer

c/c++ strptime() does not parse %Z Timezone name

I am new to C. When I practicing C to covert time sting to structure tm back and forth. I noticed some difference. Please advice what I did wrong. #include #include #include /* test different format string to…
Albert
  • 53
  • 1
  • 3
5
votes
1 answer

Change timezone component of TIMESTAMP WITH TIMEZONE in Oracle

I have some data that is stored in a TIMESTAMP(6) WITH TIMEZONE column in Oracle, but it is stored in the wrong timezone. By convention, all timestamps in the DB must be stored in UTC, but this data was incorrectly persisted as EDT. The actual…
Hank Gay
  • 70,339
  • 36
  • 160
  • 222
4
votes
1 answer

AthenaQueryError: Athena query failed: "NOT_SUPPORTED: Unsupported Hive type

I recently ran into the following error "AthenaQueryError: Athena query failed: "NOT_SUPPORTED: Unsupported Hive type", and for this I followed this stack overflow link: converting to timestamp with time zone failed on Athena error: The weird part…
Viswanatha Perala
  • 39
  • 3
4
votes
1 answer

I want to Change Timezone of Date Object In JavaScript

I want to change JavaScript Object Time zone. I am able to access time of the required timezone but date objects still shows my local timezone with it. new Date() output //Thu Nov 18 2021 16:30:23 GMT+0500 (Pakistan Standard Time) new…
Muhammad Iftikhar Rasool
  • 41
  • 3
4
votes
1 answer

How to convert PostgreSQL timestamp with time zone to Java Instant or OffSetDateTime?

How to convert PostgreSQL timestamp with time zone to Java Instant or OffSetDateTime? PostgreSQL timestamp with time zone format: 2020-06-18 16:15:38+05:30 Getting the following exception in Java 11.7 - Ubuntu for Instant.parse("2020-06-18…
Thirumal
  • 8,280
  • 11
  • 53
  • 103
4
votes
2 answers

How can I read a timestamp with timezone (timestamptz) value from PostgreSQL in Rust?

What's the right Rust data type to use for a timestamptz when using postgres version 0.17.0 with Rust 1.40.0? I read the docs for Timestamp but have no idea what this means or how to implement it. The readme for 0.17.0-alpha.1 has a table which says…
stuart
  • 1,785
  • 2
  • 26
  • 38
4
votes
2 answers

Cassandra Timestamp : Incorrect time value

I am new in Cassandra. I have a Cassandra( V: 3.11 ) table (data). It is having a column timeStampCol of timestamp type and I am inserting a value in it. insert into data (timeStampCol) values('2017-05-02 17:33:03'); While accessing the data from…
DEV
  • 2,106
  • 3
  • 25
  • 40
4
votes
1 answer

PHP timezone conversion issue

I have this function which is used to covert request date into GMT00 unix time span and store that time span into database. When i am trying to convert GMT00 time span to valid GMT timezone like GMT+4:00 then below function return wrong time…
Parth Nayak
  • 41
  • 4
  • 7
4
votes
1 answer

Why go is parsing my timestamp with Local location instead of UTC

I don't understand this behaviour (or the doc) of this: https://play.golang.org/p/vz2UTz-3Yy On the playground, it return the expected results: t = 2015-06-01 00:00:00 +0000 UTC t.Location() = UTC parsed = 2015-06-01 00:00:00 +0000…
Gravis
  • 30,149
  • 5
  • 23
  • 20
4
votes
3 answers

I want to parse string to timestamp-with-timezone in python

I try to parse string to time-stamp with timezone format. here is an example "2016-02-18 16:13:07+09" i want to know parsing this string format to time-stamp format in python. how can i do that?
Kyehee Kim
  • 89
  • 1
  • 2
  • 9
4
votes
3 answers

Php Set TimeZone

I have following code: $date = new DateTime(date("Y-m-d H:i:s"), new DateTimeZone('Asia/Karachi')); echo $date->format('Y-m-d H:i:s'); Output: 2015-08-26 17:46:05 Actual Result should be: 2015-08-26 13:46:05 How to set the time zone, so that…
Sobia Safdar
  • 83
  • 1
  • 8
4
votes
2 answers

How to convert unix timestamp (milliseconds) and timezone in R?

I have data which has two columns time and timezone that have the timestamp of events. Examples are: time timezone 1433848856453 10800000 It seems like the timestamp has fractional seconds in the information as well. I don't…
sfactor
  • 12,592
  • 32
  • 102
  • 152
4
votes
2 answers

Parsing timestamp with timezone in java?

I'm trying to parse a string of format timestamp with timezone obtained from a DB. The String is as follows : SimpleDateFormat mdyFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSSSSZ"); SimpleDateFormat sdf = new…
Karthik
  • 91
  • 3
  • 3
  • 13
4
votes
1 answer

Django Timezone aware DateTimeField default value timezone awareness error

I am trying to add a DateTimeField to my django model with the maximum timestamp as default value. I already figured out, that the maximum timestamp in Django is 9999/12/31 23:59:59 unlike the maximum timestamp used in my postgres DB. When using…
Tim
  • 1,272
  • 11
  • 28
4
votes
2 answers

How to extract consistent year from timestamptz

I'm trying to use the Postgres function extract() to get the year from a timestamptz column, but get unexpected results. I expected that it would use UTC, but appears to use whatever the local timezone of the system is (EST in my case). How do I get…
Petriborg
  • 2,940
  • 3
  • 28
  • 49
1 2
3
…
33 34