Top "Timestamp" questions

Python pytz Converting a timestamp (string format) from one timezone to another

I have a timestamp with timezone information in string format and I would like to convert this to display the …

python timezone timestamp pytz

Add 15 minutes to current timestamp using timedelta

The title says it all. I am writing a script to make scheduled GET requests to an API. I want …

python datetime timestamp typeerror timedelta

Converting bigint to timestamp in presto

I have a column in my dataset that has a datatype of bigint: Col1 Col2 1 1519778444938790 2 1520563808877450 3 1519880608427160 4 1520319586578960 5 1519999133096120 How do I convert Col2 …

date time timestamp bigint presto

alter column from time with time zone to timestamp

I am having trouble changing a column called end_date in a table called key_request from time with time …

sql postgresql timestamp postgresql-9.2 alter

TcpDump: showing the absolute timestamp (date + time) of pcap file

I want to see the absolute timestamp of the packets in a pcap file using tcpdump. When I use the …

timestamp pcap tcpdump

JPA CriteriaQuery compare Timestamp ignore time portion

Let say I have a column in Oracle DB like this: SOMETHING_TS TIMESTAMP WITH TIME ZONE And I would …

java oracle jpa timestamp criteriaquery

How to get current time in C using gettime()?

We're required to use gettime() to get the current time in C. I'm trying to print the current time but …

c timestamp gettime

Converting UNIX time to datetime object in Jinja templates

I want to convert my timestamp to datetime in jinja2.. here's my sample code: import time date = time.time() self.…

python google-app-engine timestamp python-datetime

Truncating timestamps

Let's suppose I have a timestamp variable: select timestamp '2011-02-24 08:30:42 +06:00' from dual; Is there any way to "…

sql oracle timestamp oracle11gr2

Converting Between Timezones in Postgres

I am trying to understand the timestamps and timezones in Postgre. I think I got it, until I red this …

postgresql timezone timestamp timezone-offset timestamp-with-timezone