Raj Gurung rajgurung

## postgresql_date_timestamp_interval_cheat_sheet.md

      
              1 file
            
          
              3 forks
            
          
              2 comments
            
          
              24 stars
            
          
                henryivesjones
                / postgresql_date_timestamp_interval_cheat_sheet.md
            
            
              Created
              February 14, 2023 16:56
            
              
                PostgreSQL DATE, TIMESTAMP, and INTERVAL cheat sheet
              
          
    PostgreSQL DATE, TIMESTAMP, and INTERVAL cheat sheet

Working with DATE, TIMESTAMP, and INTERVAL in PostgreSQL can be confusing. In this article I will go over the three date/time related data types, and the two most useful date/time functions: DATE_PART and DATE_TRUNC. Finally, I will provide some real life examples of how these types and functions can be used within queries.
Types

PostgreSQL Date/Time Documentation
DATE

The DATE type contains the year, month, and day of a date. It is not possible to do any type of time related functions on a DATE without first converting it to a TIMESTAMP. Subtracting two DATE values from one another results in an INT representing the # of days between.
TIMESTAMP

The TIMESTAMP type contains a year, month, day, hour, minute, second, and microsecond. This is the type that I most often use.

  
## gist:9628955
git branch -m old_branch new_branch         # Rename branch locally
git push origin :old_branch                 # Delete the old branch
git push --set-upstream origin new_branch   # Push the new branch, set local branch to track the new remote

## index.html
<html>
    <body>
        <form onsubmit="return saveText()">
            <label for="name">Name</label><br>
            <input id="name" /><br>

            <label for="desc">Description</label><br>
            <input id="desc" /><br>

            <input type="submit" value="Save" />
	git branch -m old_branch new_branch # Rename branch locally
	git push origin :old_branch # Delete the old branch
	git push --set-upstream origin new_branch # Push the new branch, set local branch to track the new remote
	<html>
	<body>
	<form onsubmit="return saveText()">
	<label for="name">Name</label><br>
	<input id="name" /><br>

	<label for="desc">Description</label><br>
	<input id="desc" /><br>

	<input type="submit" value="Save" />