Field Types Date and Time
Hi
So quite new to Mysql - Im running MYSQL 8 and need some advice please
The database will contain a table that collects information about Meteors and amongst other things we collect the date for each event and the time i.e. 18/05/2022 at 09:05:03.10
The table will contain thousands of records and I will be searching for events that occur on the same date and time Plus or Minus x deciseconds
Based on this I looking for the best way to store this info, I have had a read and there seem to be a number of options
Date, Datetime, Time etc and an awful lot of different opinions
Pointers appreciated
Kind Regards
John B
Subject
Written By
Posted
Field Types Date and Time
May 19, 2022 01:57AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.