Top "Timestamp-with-timezone" questions

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

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 : …

java timestamp timestamp-with-timezone
How to ignore time-zone on new Date()?

I have JavaScript function called updateLatestDate that receive as parameter array of objects. One of the properties of the object …

javascript timestamp-with-timezone
How to get current month firstdate and lastdate in postgres sql query

I want to get first and last dates of current month (Like 30th or 31st).How to get this one …

postgresql date timestamp-with-timezone sql-date-functions
Convert string into timestamp in Hive

I have a value '2017-09-27T19:25:15.927-07:00', is there any way to convert this into a timestamp? …

datetime hadoop hive impala timestamp-with-timezone
getting time difference with string like "A minute ago" or "An hour ago" on Android

i have this code in my PHP function nicetime($date) { date_default_timezone_set("Asia/Taipei"); if(empty($date)) { return "…

android time timestamp-with-timezone
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 …

r datetime unix-timestamp timestamp-with-timezone
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 …

c timezone strptime timestamp-with-timezone
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 …

oracle timezone timestamp ddl timestamp-with-timezone
How to pass string with ' ' (timestamp) in prepared statement?

I am trying to execute the following query INSERT INTO hotspot(timestamp) VALUES (timestamp with time zone '2012-10-25 14:00:00 +05:00…

postgresql syntax-error insert-update timestamp-with-timezone
Oracle timestamp with local time zone values transparent translation

As far as I know, TIMESTAMP WITH LOCAL TIME ZONE values are transparently translated to and from the user's session …

oracle session timezone timestamp-with-timezone