datetime
1
4.3
- noun
- /ˈdeɪtˌtaɪm/
- Specialized
:
fecha y hora
- Timestamp is the only MySQL field type that stores values relative to a timezone (namely UTC); datetime does not store according to a time zone!
Examples
-
The event time (DateTime) is always given in UTC.
Academic text (2018) -
Transactions are still happily being inserted into the database using datetime.
Blog text (9) -
The most common need for stripping time from a datetime value is to get all the rows that represent orders (or visits, or accidents) that occurred on a given day.
Blog text (10) -
I will be forwarding this article to all T-SQL coders I know who have the bad practice of converting datetime values to string prior to doing date manipulation.
Blog text (10) -
Use UTC formatted date and time values within MySQL and your application for reliability. Store all your date and time values in UTC format in a datetime column.
Blog text (9) -
You can store both the date and the time in a single datetime variable for better data management.
-
The software requires you to input a valid datetime format to record the event accurately.
-
In many programming languages, a datetime object allows you to manipulate and format dates and times easily.
Synonyms
8
3.5
A record that shows the date and time when something happened
How Precise
Surface Forms
Morphology
Etymology
Datetime is a modern compound of date and time, so it literally means a value that shows both the day and the clock moment. A helpful way to remember it is to think of a single 'stamp' that records when something happened, which is why a datetime in computing stores date and time together.