Sql

Search

mysql timestamp vs datetime

The DATETIME type is used when you need values that contain both date
and time information. MySQL retrieves and displays DATETIME values 
in 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00'
to '9999-12-31 23:59:59'.

...

The TIMESTAMP data type has a range of '1970-01-01 00:00:01' UTC 
to '2038-01-09 03:14:07' UTC. It has varying properties, 
depending on the MySQL version and the SQL mode the server is running in.

Comment

PREVIOUS	NEXT

Code Example
Sql :: sql full outer join with where clause
Sql :: Which MySQL data type to use for storing boolean values
Sql :: like in postgresql
Sql :: sql where contains part of string
Sql :: insert or ignore postgres
Sql :: SQL print multiple variable
Sql :: mysql not empty
Sql :: mysql GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Sql :: mssql procedure
Sql :: sql restore database from backup
Sql :: python sqlite3 search
Sql :: group by por mes sql mysql
Sql :: identity syntax in sql
Sql :: mysql regexp replace
Sql :: PostgreSQL: To_Number function
Sql :: sql where not like in list
Sql :: how to select all fieldsin a soql query
Sql :: mysql get only the field names in a table
Sql :: foreign key on table oracle
Sql :: case statement in select query in sql
Sql :: change password in mysql
Sql :: how to use query in nosql
Sql :: sqlite update query python
Sql :: how to get table id sequence postgres
Sql :: sql comments
Sql :: how to find sql server installation folder
Sql :: find the all the constraints in a specific table
Sql :: check if table is Temporal
Sql :: oracle boolean to varchar
Sql :: sql order of execution

Search

SQL

mysql timestamp vs datetime

ADD CONTENT