To view a commit as a diff/patch file, just add `.diff` or `.patch` to the end of the URL, for example:

 - https://github.com/weppos/whois/pull/90
 - https://github.com/weppos/whois/pull/90.diff
 - https://github.com/weppos/whois/pull/90.patch

Somewhat related, to let git download pull request 123 and patch it into `mylocalbranch` locally, run:

    git checkout -b mylocalbranch
    git pull origin pull/921/head

To get the PR changes into your local repo in an staged but uncommitted state, so you can review:

    git pull origin pull/123/head --no-commit

And to generate a patch file from that:

    git diff --cached &gt; pr123.diff    

I want to know how many milliseconds a PHP for-loop takes to execute. 

I know the structure of a generic algorithm, but no idea how to implement it in PHP:

    Begin
    init1 = timer(); // where timer() is the amount of milliseconds from midnight
    the loop begin
    some code
    the loop end
    total = timer() - init1;
    End


Accurate way to measure execution times of php scripts

I want to extract just the date part from a timestamp in PostgreSQL.

I need it to be a postgresql `DATE` type so I can insert it into another table that expects a `DATE` value.

For example, if I have `2011/05/26 09:00:00`, I want `2011/05/26`

**I tried casting, but I only get 2011:**
     
    timestamp:date
    cast(timestamp as date)


**I tried `to_char()` with `to_date()`:**

    SELECT to_date(to_char(timestamp, &#39;YYYY/MM/DD&#39;), &#39;YYYY/MM/DD&#39;) 
    FROM val3 WHERE id=1;


**I tried to make it a function:**
    
    CREATE OR REPLACE FUNCTION testing() RETURNS void AS &#39;
    DECLARE i_date DATE;
    BEGIN
        SELECT to_date(to_char(val1, &quot;YYYY/MM/DD&quot;),&quot;YYYY/MM/DD&quot;) 
          INTO i_date FROM exampTable WHERE id=1;
        INSERT INTO foo(testd) VALUES (i);
    END

What is the best way to extract date (yyyy/mm/dd) from a timestamp in PostgreSQL?

Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL

How can I download the changes contained in a Github pull request as a unified diff?

Download Github pull request as unified diff

<p>How can I download the changes contained in a Github pull request as a unified diff?</p>


I&#39;m writing a very long document in LaTeX. I have my work computer and my laptop, and I work on them both. I need to keep all the files synchronized between the two computers, and also would like to keep a revision history. I chose git as my DVCS, and I&#39;m hosting my repository on my server. I&#39;m also using Kile + Okular to do the editing. Kile doesn&#39;t have an integrated git plugin. I&#39;m also not collaborating with anyone on this text. I&#39;m also thinking about putting another private repository on codaset, if my server for some reason is not accessible.

What is the recommended workflow practice in this case? How can branching be fitted in this working scheme? Is there a way to compare two versions of the same file? What about using a stash?


git + LaTeX workflow

If `my-feature-branch` was merged into `my-main-branch`, how can I see what commits were merged in from `my-feature-branch`?

How to see commits that were merged in to a merge commit?

Is there a way to securely let git remember my credentials when connecting to remote repositories over HTTP(S)? 

I&#39;ve tried the `core.askpass` approach detailed in [`git-config`][1] to let an external script supply my credentials. Although it works great the username and password is still stored in plain text in the small shell script. 




  [1]: http://git-scm.com/docs/git-config

Git http - securely remember credentials

I am using an intermediate Git repository to mirror a remote SVN repository, from which people can clone and work on. The intermediate repository has it&#39;s master branch rebased nightly from the upstream SVN, and we are working on feature branches. For example:

    remote:
      master

    local:
      master
      feature

I can successfully push my feature branch back to the remote, and end up with what I expect:

    remote:
      master
      feature

    local:
      master
      feature

I then re-setup the branch to track the remote:

    remote:
      master
      feature

    local:
      master
      feature -&gt; origin/feature

And all is well. What I would like to do from here is to rebase the feature branch to the master branch on the remote, but I would like to do this from my local machine. I&#39;d like to be able to do:

    git checkout master
    git pull
    git checkout feature
    git rebase master
    git push origin feature

To keep the remote feature branch up-to-date with the remote master. However, this method causes Git to complain:

    To &lt;remote&gt;
     ! [rejected]        feature -&gt; feature (non-fast-forward)
    error: failed to push some refs to &#39;&lt;remote&gt;&#39;
    To prevent you from losing history, non-fast-forward updates were rejected
    Merge the remote changes (e.g. &#39;git pull&#39;) before pushing again.  See the
    &#39;Note about fast-forwards&#39; section of &#39;git push --help&#39; for details.

`git pull` does the trick but causes a merge commit that I&#39;d like to avoid. I&#39;m concerned that the message states `feature -&gt; feature` rather than `feature -&gt; origin/feature` but this may just be a presentation thing. 

Am I missing something, or going about this in completely the wrong way? It&#39;s not critical to avoid doing the rebase on the remote server, but it makes fixing any merge conflicts from the rebase much harder.

Rebasing remote branches in Git

I need to revert local changes for deployments. (I&#39;d used &lt;code&gt;svn revert&lt;/code&gt; for this in old skool SVN days.)

And im using &lt;code&gt;git reset --hard HEAD&lt;/code&gt; for this. (Also &lt;code&gt;git fetch&lt;/code&gt; and &lt;code&gt;git merge origin/$branch --no-ff&lt;/code&gt; for syncronizing with upstream branch.)

But some articles points &lt;code&gt;git checkout -f&lt;/code&gt; for reverting changes. 

What&#39;s key differences between this commands. Which way is the recommended? 

What is difference between &quot;git checkout -f&quot; and &quot;git reset --hard HEAD&quot;?

I have a fork of a Git repo and my clone appears to have an issue with an old, no longer existant, branch. I keep seeing this message:

`error: refs/heads/t_1140 does not point to a valid object!`

I don&#39;t have any other messages and the repo works fine. There&#39;s no operation that stops me from working on other branches, pushing changes, pulling...etc.

I&#39;ve looked around and there&#39;s less than clear instructions on how to get around this issue. I&#39;ve tried to execute `git fsck --full` but I see no errors. Just a load on `dangling ...` messages.

I&#39;ve also checked my `.git/config` and there&#39;s no references to this branch and have also checked `.git/refs/heads` and there&#39;s no reference to `t_1140`

Any idea how to get rid of this error?

p.s I&#39;ve tried to clone my repo again and it seems like the error is my Github repo too. So, the only thing I can think of right now is to ditch my repo and fork again.

Getting rid of &#39;... does not point to a valid object&#39; for an old git branch

I have a tmp directory in my git repo I&#39;d like to still exist, but be ignored.  I added it to `.gitignore`, but `git status` still tells me about changes to files in that directory.  I tried `git rm -r --cached`, but that removes it from the remote repo.  How can I stop tracking changes to this directory, but still allow it to exist?  I also need to do this for 1 file, but changes to that also show up in `git status` after `.gitignore`ing them.  What should I do?

using gitignore to ignore (but not delete) files

I don&#39;t want to rename a remote branch, as described in *https://stackoverflow.com/questions/1526794/rename-master-branch-for-both-local-and-remote-git-repositories?answertab=votes#tab-top*.

How can I rename a local branch which hasn&#39;t been pushed to a remote repository?

In case you need to rename a **remote** branch as well:  
*https://stackoverflow.com/questions/30590083/how-to-rename-a-remote-git-branch-name/30590238#30590238*

  [1]: https://stackoverflow.com/questions/1526794/git-rename-remote-branch



How do I rename a local Git branch?

**Latest Comment**

I believe my problem occurs when using Nuget, however, if you are reading because of the TF30063 error. Have a look at the answer I provided and accepted.

**Original Post**

I am getting this error message when I try to check out. This happens randomly and can occur even if minutes ago the same instance of visual studio allowed me to check something else out for edit.
![enter image description here][1]

The current workaround is to reopen VS2010.

Using W7x64, vs2010 ultimate with TF2010 and sql2008 on my local dev machine. I am not part of a domain. I am the administrator of this computer.


**Additional 2011-08-09**

When the problem occurrs, I &quot;close solution&quot; under file. And then reopen the solution. I then get a uid/pwd box. I put my admin uid/pwd into it and then get a further error message. Again, closing vs2010 and reopening solves the issue.

![enter image description here][2]
![enter image description here][3]

**Additional: 2011-08-30**

I believe this has to do with nuget. I have provided an answer and so far after many months I have not had a TFS error. Where I should have had an error given the types of operations I have been performing which were identical to the scenarios making it fail.

  [1]: http://i.stack.imgur.com/R375p.png
  [2]: http://i.stack.imgur.com/70kBK.png
  [3]: http://i.stack.imgur.com/ITd8M.png

TF30063: You are not authorized to access Collection. Nuget and Tfs conflicting

&gt; **Possible Duplicate:**  
&gt; [Github: Can I see the number of downloads for a repo?](https://stackoverflow.com/questions/4338358/github-can-i-see-the-number-of-downloads-for-a-repo)  

&lt;!-- End of automatically inserted text --&gt;

Can anybody tell where can I found the number of downloads of my project on GitHub?

How to see count of project downloads on GitHub?

I&#39;d like to `git clone` the contents of a repository I have on [GitHub][1]. When I `git clone` (git@github:me/name.git...) I get a folder called `name/` and inside name I have my contents... How do I get JUST the contents?

  [1]: http://en.wikipedia.org/wiki/GitHub


Clone contents of a GitHub repository (without the folder itself)

This happened when working with git on Ruby on Rails.
several commits and branches were done and created.

    git version 1.7.3.4

I accidentally deleted the **.git folder** using

    git -rf .git

but I have all the files and updates done on online git-hub repository.
I want the .git folder restored. Questions ?

 1. Am I totally screwed up ? OR 
 2. If theres a way to restore .git from my online git-hub repository, how can
   that be done ?



Can deleted .git be restored?

Is it possible to configure `git/ssh` so I don&#39;t have to enter my passphrase every time I want to perform a `git pull`?   Note that the repo is a private one on github.

Or, alternatively, what would be the best practice to automate code deployment from a private Github repo?

**Additional details:** EC2 instance running a public AMI based on Fedora.

How can I perform a `git pull` without re-entering my SSH password?

I&#39;m looking to run a Linux command that will recursively compare two directories and output **only** the file names of what is different. This includes anything that is present in one directory and not the other or vice versa, and text differences.

diff to output only the file names

I&#39;ve read through a few questions regarding file permissions in Git and I&#39;m still a bit confused. I&#39;ve got a repo on GitHub forked from another. Post merge, they should be identical. However:

    $ git diff --summary origin/epsilon master/epsilon
     mode change 100644 =&gt; 100755 ants/dist/sample_bots/csharp/compile.sh
     mode change 100644 =&gt; 100755 ants/dist/starter_bots/coffeescript/MyBot.coffee
     mode change 100644 =&gt; 100755 ants/dist/starter_bots/coffeescript/ants.coffee
     mode change 100644 =&gt; 100755 ants/util/block_test.sh
     mode change 100644 =&gt; 100755 manager/mass_skill_update.py
     mode change 100644 =&gt; 100755 worker/jailguard.py
     mode change 100644 =&gt; 100755 worker/release_stale_jails.py
     mode change 100644 =&gt; 100755 worker/start_worker.sh

I&#39;ve tried changing file permissions, but it does not alter the diff results.

Git file permissions on Windows

Every time I run git diff, for each single changes I made, I get some sort of header with numbers, for example:

    @@ -169,14 +167,12 @@ function Browser(window, document, body, XHR, $log) {.....

I wonder what does the four numbers mean? I guess -169 means that this particular line of code that follows was originally in line 169 but now is in 167? And what do 14 and 12 mean?


What do the numbers on a Git Diff header mean?

Working on a Fedora Constantine box. I am looking to `diff` two directories recursively to check for source changes. Due to the setup of the project (prior to my own engagement with said project! *sigh*), the directories contain both source and binaries, as well as large binary datasets. While diffing eventually works on these directories, it would take perhaps twenty seconds if I could ignore the binary files.

As far as I understand, diff does not have an &#39;ignore binary file&#39; mode, but does have an ignore argument which will ignore regular expression **within** a file. I don&#39;t know what to write there to ignore binary files, regardless of extension.

I&#39;m using the following command, but it does not ignore binary files. Does anyone know how to modify this command to do this?

    diff -rq dir1 dir2

diff a directory recursively, ignoring all binary files

I know that there is a post similar to this : [here][1].  
I tried using the `comp` command like it mentioned, but if I have two files, one with data like &quot;abcd&quot; and the other with data &quot;abcde&quot;, it just says the files are of different sizes. I wanted to know where exactly they differ. In Unix, the simple diff tells me which row and column, the comp command in windows works if I have something like &quot;abd&quot; and &quot;abc&quot;. Not otherwise. Any ideas what I can use for this?


  [1]: https://stackoverflow.com/questions/1011269/how-to-do-diff-r-of-unix-in-windows-cmd-prompt

Content Type	Original Author	Original Content on Stackoverflow
Question	Thilo	View Question on Stackoverflow
Solution 1 - Git	Simone Carletti	View Answer on Stackoverflow
Solution 2 - Git	thakis	View Answer on Stackoverflow
Solution 3 - Git	Bill Hollings	View Answer on Stackoverflow

Download Github pull request as unified diff

Git Problem Overview

Git Solutions

Solution 1 - Git

Solution 2 - Git

Solution 3 - Git

Extract date (yyyy/mm/dd) from a timestamp in PostgreSQL

Accurate way to measure execution times of php scripts

Attributions