Questions tagged [unix-timestamp]
The number of seconds between a particular date and the Unix Epoch on January 1st, 1970
299
questions
1134
votes
20
answers
1.7m
views
Converting unix timestamp string to readable date
I have a string representing a unix timestamp (i.e. "1284101485") in Python, and I'd like to convert it to a readable date. When I use time.strftime, I get a TypeError:
>>>import ...
- 11.4k
156
votes
20
answers
468k
views
How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
How can I convert UNIX timestamp (bigint) to DateTime in SQL Server?
- 1,996
658
votes
18
answers
852k
views
How to get the unix timestamp in C#
I have had look around stackoverflow, and even looked at some of the suggested questions and none seem to answer, how do you get a unix timestamp in C#?
- 20.8k
222
votes
5
answers
325k
views
Convert unix time to readable date in pandas dataframe
I have a dataframe with unix times and prices in it. I want to convert the index column so that it shows in human readable dates.
So for instance I have date as 1349633705 in the index column but I'...
- 2,303
311
votes
3
answers
386k
views
Getting "unixtime" in Java
Date.getTime() returns milliseconds since Jan 1, 1970. Unixtime is seconds since Jan 1, 1970. I don't usually code in java, but I'm working on some bug fixes. I have:
Date now = new Date();
...
- 16.4k
240
votes
10
answers
626k
views
Converting a UNIX Timestamp to Formatted Date String
Using PHP, I want to convert UNIX timestamps to date strings similar to this: 2008-07-17T09:24:17Z
How do I convert a timestamp such as 1333699439 to 2008-07-17T09:24:17Z?
- 10k
70
votes
3
answers
171k
views
Convert unix timestamp to date in java [duplicate]
How can I convert minutes from Unix timestamp to date and time in java? For example, timestamp 1372339860 correspond to Thu, 27 Jun 2013 13:31:00 GMT.
I want to convert 1372339860 to 2013-06-27 13:31:...
- 1,318
244
votes
7
answers
150k
views
Do UNIX timestamps change across timezones?
As the subject asks; do UNIX timestamps change in each timezone?
For example, if I sent a request to another email the other side of the world saying, "Send out an email when the time is 1397484936", ...
- 3,405
166
votes
4
answers
406k
views
MySQL convert date string to Unix timestamp
How do I convert the following format to unix timestamp?
Apr 15 2012 12:00AM
The format I get from DB seems to have AM at the end.
I've tried using the following but it did not work:
CONVERT(...
- 2,303
7
votes
4
answers
11k
views
How to Convert UNIX epoch time to Date and time in ios swift
I'm trying to convert the UNIX epoc time to datetime format using the below code
var epocTime = NSTimeInterval(1429162809359)
let myDate = NSDate(timeIntervalSince1970: epocTime)
println("Converted ...
- 111
63
votes
4
answers
34k
views
Unix time and leap seconds
Regarding Unix (POSIX) time, Wikipedia says:
Due to its handling of leap seconds, it is neither a linear representation of time nor a true representation of UTC.
But the Unix date command does ...
- 4,435
16
votes
1
answer
64k
views
Date time conversion from timezone to timezone in sql server
I having an column of UNIX time stamp in my database table, which comes from a system that is in the Kuwait time zone.
My database server's time zone is Eastern Time US & Canada. Now I need to ...
- 2,636
213
votes
13
answers
435k
views
Convert normal date to unix timestamp
How can I convert normal date 2012.08.10 to unix timestamp in javascript?
Fiddle: http://jsfiddle.net/J2pWj/
I've seen many posts here that convert it in PHP, Ruby, etc... But I need to do this ...
- 26.3k
287
votes
9
answers
468k
views
Convert Unix timestamp into human readable date using MySQL
Is there a MySQL function which can be used to convert a Unix timestamp into a human readable date? I have one field where I save Unix times and now I want to add another field for human readable ...
- 11.2k
47
votes
6
answers
60k
views
Python fromtimestamp OSError
For some reason when constructing datetimes using fromtimestamp, I get a
"OSError [Errno22] Invalid Argument"
when I use negative times less than -43200 (-12hrs).
I am on Win7 64-bit and ...
- 471