I have a string representing a unix timestamp (i.e. &quot;1284101485&quot;) in Python, and I&#39;d like to convert it to a readable date. When I use `time.strftime`, I get a `TypeError`:

&lt;!-- language: lang-python --&gt;

    &gt;&gt;&gt;import time
    &gt;&gt;&gt;print time.strftime(&quot;%B %d %Y&quot;, &quot;1284101485&quot;)

    Traceback (most recent call last):
      File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt;
    TypeError: argument must be 9-item sequence, not str



Converting unix timestamp string to readable date

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#?

How to get the unix timestamp in C#

I need a shell command or script that converts a Unix timestamp to a date. The input can come either from the first parameter or from stdin, allowing for the following usage patterns:

    ts2date 1267619929
and

    echo 1267619929 | ts2date

Both commands should output &quot;Wed Mar  3 13:38:49 2010&quot;.


How to convert timestamps to dates in Bash?

*Related question is [&quot;Datetime To Unix timestamp&quot;][1], but this question is more general.* 

I need Unix timestamps to solve my [last question.][2] My interests are Python, Ruby and Haskell, but other approaches are welcome.

**What is the easiest way to generate Unix timestamps?**

  [1]: https://stackoverflow.com/questions/455554/datetime-to-unix-timestamp
  [2]: https://stackoverflow.com/questions/1204059/find-command-search-with-created-time/1204329#1204329

How can I generate Unix timestamps?

I have to create an &quot;Expires&quot; value 5 minutes in the future, but I have to supply it in UNIX Timestamp format.  I have this so far, but it seems like a hack.

    def expires():
        &#39;&#39;&#39;return a UNIX style timestamp representing 5 minutes from now&#39;&#39;&#39;
        epoch = datetime.datetime(1970, 1, 1)
        seconds_in_a_day = 60 * 60 * 24
        five_minutes = datetime.timedelta(seconds=5*60)
        five_minutes_from_now = datetime.datetime.now() + five_minutes
        since_epoch = five_minutes_from_now - epoch
        return since_epoch.days * seconds_in_a_day + since_epoch.seconds

Is there a module or function that does the timestamp conversion for me?



Python Create unix timestamp five minutes in the future

Date.getTime() returns milliseconds since Jan 1, 1970. Unixtime is seconds since Jan 1, 1970. I don&#39;t usually code in java, but I&#39;m working on some bug fixes. I have:

    Date now = new Date();		
    Long longTime = new Long(now.getTime()/1000);
    return longTime.intValue();

Is there a better way to get unixtime in java?

Getting &quot;unixtime&quot; in Java

Python provides different packages (`datetime`, `time`, `calendar`) as can be seen [here][1] in order to deal with time. I made a big mistake by using the following to get current GMT time `time.mktime(datetime.datetime.utcnow().timetuple())`

What is a simple way to get current GMT time in Unix timestamp?


  [1]: https://stackoverflow.com/questions/8542723/change-datetime-to-unix-time-stamp-in-python

What is the easiest way to get current GMT time in Unix timestamp format?

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 dates.

Convert Unix timestamp into human readable date using MySQL

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`?

Converting a UNIX Timestamp to Formatted Date String

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, **&quot;Send out an email when the time is 1397484936&quot;**, would the other server&#39;s timestamp be 12 hours behind my own?

Do UNIX timestamps change across timezones?

I&#39;m trying to parse an Unix [timestamp][1] but I get out of range error. That doesn&#39;t really makes sense to me, because the layout is correct (as in the Go docs):

    package main
    
    import &quot;fmt&quot;
    import &quot;time&quot;
    
    func main() {
        tm, err := time.Parse(&quot;1136239445&quot;, &quot;1405544146&quot;)
        if err != nil{
            panic(err)
        }

        fmt.Println(tm)
    }

[Playground][2]


  [1]: https://golang.org/pkg/time/
  [2]: https://play.golang.org/p/lFxVml0qH4

How to parse unix timestamp to time.Time

I have an X.509 certificate which has the following 2 timestamps:

    [&#39;validFrom&#39;] = String(13) &quot;120314165227Z&quot;
    [&#39;validTo&#39;]   = String(13) &quot;130314165227Z&quot;

What does the postfix character &#39;Z&#39; mean. Does it specify the timezone?

What does the &#39;Z&#39; mean in Unix timestamp &#39;120314170138Z&#39;?

How can I convert normal date `2012.08.10` to unix timestamp in javascript?

Fiddle: http://jsfiddle.net/J2pWj/
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
I&#39;ve seen many posts here that convert it in PHP, Ruby, etc... But I need to do this inside JS.

Convert normal date to unix timestamp

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&#39;d want it to show as `10/07/2012` (or at least `10/07/2012 18:15`). 

For some context, here is the code I&#39;m working with and what I&#39;ve tried already:

    import json
    import urllib2
    from datetime import datetime
    response = urllib2.urlopen(&#39;http://blockchain.info/charts/market-price?&amp;format=json&#39;)
    data = json.load(response)   
    df = DataFrame(data[&#39;values&#39;])
    df.columns = [&quot;date&quot;,&quot;price&quot;]
    #convert dates 
    df.date = df.date.apply(lambda d: datetime.strptime(d, &quot;%Y-%m-%d&quot;))
    df.index = df.date   

As you can see I&#39;m using
`df.date = df.date.apply(lambda d: datetime.strptime(d, &quot;%Y-%m-%d&quot;))` here which doesn&#39;t work since I&#39;m working with integers, not strings. I think I need to use `datetime.date.fromtimestamp` but I&#39;m not quite sure how to apply this to the whole of `df.date`. 

Thanks.

Convert unix time to readable date in pandas dataframe

I want to get the Unix TimeStamp using Moment.js.
I can find many functions which convert timestamp to date in moment.js.
I know that I can easily get the unix timestamp by using the following JavaScript function: `Math.floor(new Date().getTime()/1000)`.

But I want to use Moment.js to get the same result.
Is there any direct function in moment.js to get the current timestamp?

Getting current unixtimestamp using Moment.js

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&#39;ve tried using the following but it did not work:

    CONVERT(DATETIME, Sales.SalesDate, 103) AS DTSALESDATE,  
    CONVERT(TIMESTAMP, Sales.SalesDate, 103) AS TSSALESDATE

    where Sales.SalesDate value is Apr 15 2012 12:00AM

MySQL convert date string to Unix timestamp

Is there a quick, one-liner way to convert a Unix timestamp to a date from the Unix command line?

`date` might work, except it&#39;s rather awkward to specify each element (month, day, year, hour, etc.), and I can&#39;t figure out how to get it to work properly. It seems like there might be an easier way&amp;hairsp;—&amp;hairsp;am I missing something?

Convert Unix timestamp to a date string

How to convert an `NSDate` into Unix timestamp? I&#39;ve read many posts which do the reverse. But I&#39;m not finding anything related to my question.

How to convert NSDate into unix timestamp iphone sdk?

The following returns time in microseconds, for example 4565212462.

    alert( $.now() );

How do I convert it to a human readable time format, such as  **(hours:minutes:seconds)**?



How to get current time with jQuery

How can I convert UNIX timestamp (bigint) to DateTime in SQL Server?

How can I convert bigint (UNIX timestamp) to datetime in SQL Server?

How can I get Unix time in Go in milliseconds?

I have the following function:

    func makeTimestamp() int64 {
    	return time.Now().UnixNano() % 1e6 / 1e3
    }

I need less precision and only want milliseconds. 




Go time.Now().UnixNano() convert to milliseconds?

I have a millisecond timestamp that I need to convert from a string to long. JavaScript has a `parseInt` but not a `parseLong`. So how can I do this?

To expand on my question slightly: given that apparently JavaScript doesn&#39;t have a long type, how can I do simple arithmetic with longs that are initially expressed as strings? E.g subtract one from the other to get a time delta?

How to convert a String to long in javascript?

How to sort the files according to the time stamp in unix?
I need to sort the files and also based on time they created.

How to sort the files according to the time stamp in unix?

I have a Unix timestamp like this:

    $timestamp=1330581600

How do I get the beginning of the day and the end of the day for that timestamp?

    e.g.
    $beginOfDay = Start of Timestamp&#39;s Day
    $endOfDay = End of Timestamp&#39;s Day

I tried this:

    $endOfDay = $timestamp + (60 * 60 * 23);

But I don&#39;t think it&#39;ll work because the timestamp itself isn&#39;t the exact beginning of the day.


Given a Unix timestamp, how to get beginning and end of that day?

I have a basic method which gets the current time and sets it in a string. However, how can I get it to format the current date &amp; time in a UNIX since-1970 timestamp format?

Here is my code:

    NSDate *currentTime = [NSDate date];
    NSDateFormatter *dateFormatter = [[NSDateFormatter alloc] init];
    [dateFormatter setDateFormat:@&quot;hh-mm&quot;];
    NSString *resultString = [dateFormatter stringFromDate: currentTime];

Is it possible to use `NSDateFormatter` to change the &#39;resultString&#39; into a timestamp?

Get current NSDate in timestamp format

I have a string and I need to find out whether it is a unix timestamp or not, how can I do that effectively?

I found &lt;a href=&quot;http://www.sitepoint.com/forums/showthread.php?t=585963&quot;&gt;this thread&lt;/a&gt; via Google, but it doesn&#39;t come up with a very solid answer, I&#39;m afraid. (And yes, I cribbed the question from the original poster on the aforementioned thread).





Check whether the string is a unix timestamp

Trying to convert 1504865618099.00 Unix time into a readable date time.
I tried this:

  

    =(UNIX + (&quot;1/1/1970&quot;-&quot;1/1/1900&quot;+1)*86400) / 86400

But it&#39;s not working.

Converting unix time into date-time via excel

I have a logging table that will contain millions of writes for statistical reasons. All the columns are int foreign keys. I am also going to add a timestamp column for each row. Given that DATETIME takes 8bits - I will be using `int(10) unsigned` to cut the storage space (and index on that column) in half. 

However, I&#39;m wondering when this column would no longer work. At 3:14:07AM on 19th January 2038 the value 9,999,999,999 will be a problem for UNIX timestamps - but an unsigned int in MySQL only holds up to 4,294,967,295 and the timestamp 4294967295 is showing an invalid number in my PHP application.

**So what does this mean? Is the end of the storing int timestamps in MySQL going to be sometime in 2021 since it can&#39;t make it all the way to 9999999999?**

**Answer:** 

 1. 2147483647 is 2038 (not 9999999999) so there is no problem. 
 2. `unsigned` isn&#39;t needed since 2147483647 fits fine in a signed MySQL int.

How should unix timestamps be stored in int columns?

How do I convert a human-readable time such as `20.12.2016 09:38:42,76` to a Unix timestamp in **milliseconds**?

Convert python datetime to timestamp in milliseconds

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:00 GMT`.

Edit: Actually I want it to be according to US timing GMT-4, so it will be `2013-06-27 09:31:00`.

Convert unix timestamp to date in java

I&#39;m using the Mongo shell to query my Mongo db.  I want to use the timestamp contained in the ObjectID as part of my query and also as a column to extract into output.  I have setup Mongo to create ObjectIDs on its own.

My problem is I can not find out how to work with the ObjectID to extract its timestamp.

Here are the queries I am trying to get working.  The &#39;createdDate&#39; field is a placeholder; not sure what the correct field is:

    //Find everything created since 1/1/2011
    db.myCollection.find({date: {$gt: new Date(2011,1,1)}});
    
    //Find everything and return their createdDates
    db.myCollection.find({},{createdDate:1});

How do I extract the created date out of a Mongo ObjectID

How do I create a Unix timestamp on Android?

I want to create a URL post request with a Unix timestamp on the end of the url.

How do I create a Unix timestamp on Android?

The `ObjectId` used as the default key in mongodb documents has embedded timestamp (calling objectid.generation_time returns a datetime object). So it is possible to use this generation time instead of keeping a separate creation timestamp? How will you be able to sort by creation time or query for the last N items efficiently using this embedded timestamp?



uses for mongodb ObjectId creation time

I am making a countdown timer for an event page, i used moment js for this.  

Here is [fiddle][1] for this.

I am calculating date difference between event date and current date (timestamp), then using &quot;duration&quot; method from moment js.  But the time left is not coming as expected.  
**Expected** - 00:30m:00s  
**Actual** - 5h:59m:00s  

Code :   
 

    &lt;script&gt;
      $(document).ready(function(){
    
        var eventTime = &#39;1366549200&#39;;
        var currentTime = &#39;1366547400&#39;;
        var time = eventTime - currentTime;
        var duration = moment.duration(time*1000, &#39;milliseconds&#39;);
        var interval = 1000;
    
        setInterval(function(){
          duration = moment.duration(duration.asMilliseconds() - interval, &#39;milliseconds&#39;);
          $(&#39;.countdown&#39;).text(moment(duration.asMilliseconds()).format(&#39;H[h]:mm[m]:ss[s]&#39;));
        }, interval);
      });
      &lt;/script&gt;

I read the momentjs documentation to figure out the problem, but no luck.

Thanks for your time.


**Update :**    

I end up doing like this :   
 
    &lt;script&gt;
      $(document).ready(function(){
    
        var eventTime = &#39;1366549200&#39;;
        var currentTime = &#39;1366547400&#39;;
        var leftTime = eventTime - currentTime;//Now i am passing the left time from controller itself which handles timezone stuff (UTC), just to simply question i used harcoded values.
        var duration = moment.duration(leftTime, &#39;seconds&#39;);
        var interval = 1000;
    
        setInterval(function(){
          // Time Out check
          if (duration.asSeconds() &lt;= 0) {
            clearInterval(intervalId);
            window.location.reload(true); #skip the cache and reload the page from the server
          }

          //Otherwise
          duration = moment.duration(duration.asSeconds() - 1, &#39;seconds&#39;);
          $(&#39;.countdown&#39;).text(duration.days() + &#39;d:&#39; + duration.hours()+ &#39;h:&#39; + duration.minutes()+ &#39;m:&#39; + duration.seconds() + &#39;s&#39;);
        }, interval);
      });
      &lt;/script&gt;

[JS Fiddle][2].


  [1]: http://jsfiddle.net/wt812nfo/
  [2]: http://jsfiddle.net/arpit/cxyms

Countdown timer using Moment js

I have the following entry in my DB table

    eventName(varchar 100) -&gt; myEvent
    date(timestamp) -&gt; 2013-03-26 09:00:00

and I am trying to use the following query;

    SELECT * 
    FROM eventList 
    WHERE `date` BETWEEN UNIX_TIMESTAMP(1364256001) AND UNIX_TIMESTAMP(1364342399)

i.e between 2013-03-26 00:00:01 and 2013-03-26 23:59:59

but it is giving me 0 results.

I have tried expanding the date range with no luck and there are definitely results within the range.

any help is appreciated.

MYSQL query between two timestamps

I used &quot;touch&quot; on a file, updating the file&#39;s timestamp but the parent directory&#39;s timestamp did not change.  However, (as expected) when I created a new file within the parent directory, the directory&#39;s timestamp did change.

What criteria do UNIX-like operating systems (specifically AIX) use to determine when to update the timestamp of a directory?



When does a UNIX directory change its timestamp

If my Unix machine is set to IST timezone, how can I get the current GMT time?

How do I get GMT time in Unix?

Regarding Unix (POSIX) time, [Wikipedia][1] says: 

&gt; 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 not seem to be aware of them actually

&lt;!-- language: lang-bsh --&gt;

    $ date -d &#39;@867715199&#39; --utc
    Mon Jun 30 23:59:59 UTC 1997
    $ date -d &#39;@867715200&#39; --utc
    Tue Jul  1 00:00:00 UTC 1997

While there should be a leap second there at `Mon Jun 30 23:59:60 UTC 1997`.

Does this mean that only the `date` command ignores leap seconds, while the *concept* of Unix time doesn&#39;t?

  [1]: http://en.wikipedia.org/wiki/Unix_time

Unix time and leap seconds

How do I convert the following format to UNIX timestamps?

A value like: `01-02-2015 10:20 PM` should be converted to: `1418273999000`

I did try `to_timestamp` function but its not working for me.

All Unix Timestamp Solutions on Gang of Coders

Total of 39 Unix Timestamp Solutions