Sql

Search

which takes more space in a database a datetime or separate date and time columns?

/* If you have need of both a date and time, it is usually better to use a 
   datetime datatype. It makes most queries slightly easier by not having
   to combine data from different columns to get a particular moment.
   
   It visually takes up less space in a DB, and it is also more common 
   practice, so has wider support.
   
   Exceptions include when legacy support is needed for separate fields.   */

Comment

PREVIOUS	NEXT

Code Example
Sql :: nested query with all examples
Sql :: mariadb select limit offset
Sql :: date query
Sql :: alembic upgrade show sql
Sql :: group_concat only returns one row
Sql :: dump a single table named mytab
Sql :: create table as select sql server error
Sql :: amount to words oracle Function
Sql :: sqlite3 not commit
Sql :: sql how to display two atributes as one in sql
Sql :: online t-sql editor
Sql :: ring get columns count in the query result using the odbc_colcount()
Sql :: how much space does sql server take per row
Sql :: PROSYS SQL
Sql :: tsql create table with variable name
Sql :: does sql auto increment start at number if it is removed?
Sql :: openquery update linked server
Sql :: VYSTUPNI PARAMETR ULOZENE PROCEDURY SQL
Sql :: strftime format sqlite
Sql :: how to escape single quotes in SQL
Sql :: set mysql socket file docker windows
Sql :: how to fix mysql stop unexpectedly
Sql :: ltrim entire column sql select query
Sql :: order by monthly in sql
Sql :: characters found after end of sql statement
Sql :: mysql faster delete
Sql :: Oracle Function call - 12C
Sql :: How is the default tablespace determined when creating a table?
Sql :: sql query to find difference between total no. of rows and distinct rows in sql server
Sql :: best practive to pass multiple table to stored procedure in sql server

Search

SQL

which takes more space in a database a datetime or separate date and time columns?

ADD CONTENT