Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How does MySQL store timestamps internally?

Tags:

types

sql

timestamp

mysql

How does MySQL store timestamps internally? Is it an int, or a string or something else?

like image 385
UnkwnTech Avatar asked Oct 13 '09 23:10

UnkwnTech

1 Answers

From the MySQL Documentation:

TIMESTAMP: A four-byte integer representing seconds UTC since the epoch ('1970-01-01 00:00:00' UTC)

like image 176
Asaph Avatar answered Sep 17 '22 12:09

Asaph
Sign in to Comment

Related questions

Left join without multiple rows from right table
Using SqlQuery<Dictionary<string, string>> in Entity Framework 6
How can I get a count of a bit-type column?
SQL schema pattern for keeping history of changes
Is it possible to update rows from a key/value pair?
Display value of attribute of type SDO_GEOMETRY
SQL Convert Week Number to Date (dd/MM)
Similar function to SQL 'WHERE' clause in R
CTE and table update in ORACLE
How to Execute sql queries in Apache Spark
pyspark - create DataFrame Grouping columns in map type structure
Is it possible to combine Group by, Having and Sum?
'limit' clause in Oracle SQL "SQL command not properly ended" [duplicate]
MySQL error: Missing index for constraint
Starting Django with docker unexpected character
How do I do multiple updates in a single SQL query?
Is there a way to parser a SQL query to pull out the column names and table names?
What relational database innovations have there been in the last 10 years
SQL: Use multiple values in single SELECT statement
JDBC Timestamp & Date GMT issues

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!