SQL DATETIME Column Guide

1 year ago
Sophia Anderson
1 minute

When creating database tables, the DATETIME data type can be used to define columns for dates and times. The DATETIME data type can store values for both dates and times in the format YYYY-MM-DD HH:MM:SS. Here is an example SQL statement for creating a table with a DATETIME column:

CREATE TABLE example_table (
    id INT PRIMARY KEY,
    event_name VARCHAR(255),
    event_date DATETIME
);

In the example above, the table `example_table` contains three columns: `id` is an integer type primary key column, `event_name` is a VARCHAR type column used to store event names, and `event_date` is a DATETIME type column used to store the date and time when the event occurred. Defining the DATETIME column this way allows for storing and retrieving date and time information in the database.

bannerAds