In what type of data in Mysql to store unix time?

G

G

gomerIT2020-09-30 14:57:20

MySQL

gomerIT, 2020-09-30 14:57:20

In what type of data in Mysql to store unix time?

I need to store unix time in a database, but I don't know what type of data to choose

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander, 2020-09-30
@gomerIT

UNIXTIME is a number, so you need to store it in INTEGER.
insert a number, extract either a number or using the date function.
Here are mysql + php examples .

Similar questions

A

Anholle2019-09-09 11:37:42

How to set up a filter in the feedback form? 0Reply

S

sl02020-05-13 19:43:45

How to competently build sql queries in highly loaded databases? 3Reply

S

Salavat Sitdikov2012-04-09 09:30:22

Is it possible to do this with one sql query? 4Reply

V

viktorross2020-05-13 23:22:00

Mysql left join query, how to fix? 0Reply

R

Robot2015-11-18 11:17:26

How would you store the date, time? 3Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question