In the above query, three different DateTime functions are used to insert the current timestamp in the “staff_info” table: The inbuilt date functions like NOW(), CURRENT_TIMESTAMP and LOCALTIMESTAMP can be used with the INSERT statement to insert the current timestamp into a Postgres table: INSERT INTO staff_info(e_id, e_name, e_joining_date) Let’s fetch the newly inserted record via the “SELECT” command: SELECT * FROM staff_info Ī particular timestamp has been inserted into the staff_info table.Įxample 3: Inserting the Current Timestamp Into a Postgres Table Use the INSERT query to insert a particular timestamp into the “staff_info” table: INSERT INTO staff_info(e_id, e_name, e_joining_date) Note: Use the TIMESTAMPTZ data type instead of the TIMESTAMP to store the DateTime values along with the time zone.Įxample 2: Inserting a Specific Timestamp Into a Postgres Table The “staff_info” table with the specified columns has been successfully created. Let’s create a sample table named staff_info with the following columns: e_id, e_name, and e_joining_date: CREATE TABLE staff_info( in place of constraint.Įxample 1: Creating a Table Column With Timestamp Specify the constraint of your choice such as PRIMARY KEY, CHECK, UNIQUE, etc. Use either TIMESTAMP or TIMESTMAPTZ data type. col_name represents a column to be defined with the TIMESTAMP data type. Utilize the following syntax to create/define a table’s column with TIMESTAMP data type: CREATE TABLE tab_name(Ĭol_name TIMESTAMP | TIMESTAMPTZ constraint For instance, the TIMESTAMP data type can be handy in scenarios where we have to maintain the staff’s check-in and check-out record, the customer’s order placement DateTime, the flight’s arrival and departure record, etc.
The need for the TIMESTAMP data type arises when we have to keep/save the date and time values in a particular database.
#Postgresql timestamp create table how to#
How to Insert a Timestamp into a Postgres Table?
This Postgres blog presents a detailed guide on how to insert the current or any specific timestamp in Postgres. A table’s column created with TIMESTAMP or TIMESTAMPTZ data type has the ability to store the current timestamp or any specific timestamp. Among them, the TIMESTAMP and TIMESTAMPTZ are used to store the date and time values with or without time zone information. Postgres supports various temporal data types, such as DATE, TIMESTAMP, TIME, etc.
0 kommentar(er)
