[PYTHON/PSYCOPG2] 날짜/시간 처리하기


CREATE TABLE item
(
    item_id       INTEGER NOT NULL PRIMARY KEY,
    item_name     VARCHAR (100) NOT NULL,
    purchase_time TIMESTAMP NOT NULL,
    price         INTEGER NOT NULL
);

1

2

3

4

5

6

7

8

9

CREATE TABLE item

(

item_id INTEGER NOT NULL PRIMARY KEY,

item_name VARCHAR (100) NOT NULL,

purchase_time TIMESTAMP NOT NULL,

price INTEGER NOT NULL

);


import datetime
import psycopg2

connection = psycopg2.connect(host = "192.168.29.118", port = "5432", database = "testdb", user = "testuser1", password = "test1234")

cursor = connection.cursor()

cursor.execute("DELETE FROM item;")

cursor.execute(
    "INSERT INTO item (item_id, item_name, purchase_time, price) VALUES (%s, %s, %s, %s)",
    (12, "Keyboard", datetime.datetime.now(), 150)
)

connection.commit()

cursor.execute("SELECT purchase_time from item where item_id = 12")

purchaseTime = cursor.fetchone()

print("항목 구매 일자 :", purchaseTime[0].date())
print("항목 구매 시간 :", purchaseTime[0].time())

cursor.close()
connection.close()

"""
항목 구매 일자 : 2024-06-01
항목 구매 시간 : 00:58:33.167324
"""

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

import datetime

import psycopg2

connection = psycopg2.connect(host = "192.168.29.118", port = "5432", database = "testdb", user = "testuser1", password = "test1234")

cursor = connection.cursor()

cursor.execute("DELETE FROM item;")

cursor.execute(

"INSERT INTO item (item_id, item_name, purchase_time, price) VALUES (%s, %s, %s, %s)",

(12, "Keyboard", datetime.datetime.now(), 150)

)

connection.commit()

cursor.execute("SELECT purchase_time from item where item_id = 12")

purchaseTime = cursor.fetchone()

print("항목 구매 일자 :", purchaseTime[0].date())

print("항목 구매 시간 :", purchaseTime[0].time())

cursor.close()

connection.close()

"""

항목 구매 일자 : 2024-06-01

항목 구매 시간 : 00:58:33.167324

"""


psycopg2-binary==2.9.9

1

2

3

psycopg2-binary==2.9.9