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
-1
votes
1 answer

How to get time from String (14-04-2021 18:04:87) in Java?

How to get time from String (14-04-2021 18:04:87) ? How to get only time from this String "14-04-2021 18:04:87" ? I need output as 06:04 pm
Beginner Dev
  • 19
  • 5
-1
votes
3 answers

How to parse UTC timestamp of format yyyy-MM-ddTHH:mm:ss.SSS+ZZZZ

I have timestamp as 2020-12-03T05:35:59.398+0000 in String format being recieved in a streaming batch. I want only 2020-12-03 05:35:59 as java.sql.Timestamp instance in order to be able to compare it with other Timestamp instance. Getting following…
Harshvardhan Solanki
  • 647
  • 2
  • 11
  • 32
-1
votes
2 answers

Converting string timestamp to local-time zone in Oracle

I'm trying to sum data usage for mobile multiple mobile numbers world wide using oracle database,to achieve accurate result my SQL query need to to convert this string timestamp to my local time zone +03 ,for example the expected time for the first…
Osama Al-Banna
  • 1,465
  • 5
  • 20
  • 33
-1
votes
1 answer

timezone reconciliation with SQL

Question 1/3: I have a number of MySQL databases to connect to and want to ensure time consistency across queries. So for example, one of these servers is currently in the CDT timezone. > select CURRENT_TIMESTAMP, @@system_time_zone,…
colm.anseo
  • 19,337
  • 4
  • 43
  • 52
-1
votes
1 answer

Converting a matrix of unix timestamps into human times in R

I've a 14 x 2 matrix of human times, called TH, as the output of an R code; however, the output of TH is as follows: [1] "2018-01-24 00:00:00 CET" "2018-01-24 00:24:34 CET" "2018-01-24 08:32:22 CET" [4] "2018-01-24 08:42:12 CET" "2018-01-24…
Noprogexprnce mathmtcn
  • 247
  • 3
  • 16
-1
votes
1 answer

TimeStamp to String Android

Server gives me time in this format: Tue Jan 10 03:48:45 GMT+05:30 2017" I want to convert it into: Tue,Jan 2017" I have searched google for a while now, still no luck. How can I do this?
Joko NdiOha
  • 31
  • 3
-1
votes
1 answer

How do I return the current time in c# when the time zone changes using the NSTimeZone in iOS

I'm using xamarin to develop an iOS app, and need to be able to determine the actual time(FYI..12:00 AM) based on the timezone in C#. I'm using the NSTimeZone object to determine the time zone, but can't seem to figure out how to determine the…
Ramell Lamar
  • 1
  • 2
-1
votes
1 answer

Convert and Store Date and Time in other coloumn in MySQL

I have database in MYSQL with ID, Req_Order_No(Varchar) , Req_In_Time(DateTime), Req_Out_Time(DateTime) The Sample row is like below: 1 W0CH546 2014-07-23 09:32:00 2014-07-24 01:42:00 The above Date and Time are in EST format. I want to…
user3766876
  • 15
  • 6
-1
votes
1 answer

Inserting a date in RFC2822 format - no timezone specifier?

I have a string in RFC2822 format and I would like to insert the appropiate timestamp in UTC time. Until now I've come up with DATE_FORMAT(?, "%a, %d %b %Y %T -0700") but the problem is the TZ offset -0700, there seems to be no format specifier for…
Flavius
  • 13,566
  • 13
  • 80
  • 126
-2
votes
4 answers

how to convert Timestamp in milliseconds to javascript ? (in React)

Consider code below, const appointments = [ { // id: 0, title: 'Watercolor Landscape', users_id: 2, startDate: new Date(1584576000000 * 1000), // here is timestamps in milliseconds endDate: new Date(1584662400000* 1000), …
koko ka
  • 107
  • 4
  • 17
-2
votes
1 answer

Group By week and week starts from Tuesday

Here is my data table: invoice_id invoice_line store_id time_stamp product units sales cogs 10000001 31215 3 9/3/17 3000 1 99.99 58.00 10000001 31216 3 9/3/17 3354H 3 …
Rashida
  • 401
  • 7
  • 18
-2
votes
1 answer

How to Convert a Date and Time into miliseconds that goes as an argument for Timestamp?

enter image description here I have been trying to convert a given date and time into milliseconds as I want to upload it as a timestamp but this is giving me Exception "java.time.format.DateTimeParseException: Text '2019/2/29 17:59:00' could not be…
Aditya Dhanraj Saha
  • 1
  • 2
-2
votes
1 answer

How do I convert a string of the form 'YYYY-DD-MM HH:MI:SS.MS +00:00' where last four chars are a timezone offset into a postgres timestamptz?

How do I convert a string of the form 'YYYY-DD-MM HH:MI:SS.MS +00:00' where last four chars are a timezone offset into a postgres timestamptz? This does not seem to work: select '2018-06-13 04:11:46.873 -07:00'::timestamptz; timestamptz …
Jerry Asher
  • 836
  • 2
  • 10
  • 23
-3
votes
1 answer

ORACLE Procedure with TIMESTAMP

I try to write a procedure to know the datetime from a timezone to another timezone I can't compile because the format date is not valid and I don't know how to manage the variable. Can you give me a tip, please create or replace PROCEDURE…
Zako
  • 3
  • 1
-4
votes
1 answer

Given 2 LocalDateTime generate filters based on days or days/hours

I would like to have a method that given a time interval granularity (e.g. DAY, HOUR, etc.) and 2 LocalDateTime a and b generates a string of the following type: let's assume a = '2018-01-01 12:23:23' and b = '2018-01-10 15:18:13' if the time…
alexlipa
  • 1,131
  • 2
  • 12
  • 27
1 2 3
…
33
34