Re: Date/Time Query

[Rick James]

I'll agree with Mark. And suggest two ways:

1. Write a program to read the csv, massage the data, then INSERT.

2. Insert the CSV data as-is. Then have SQL statements (and possible some code) massage the data, putting the cleansed data into another table.

I recommend you use a DOUBLE field for the date and time (call it tim). Take the part before the decimal point, convert to a UNIX_TIMESTAMP, then add the fractional part. This will fit nicely in a DOUBLE. Then, when you need decide if an item is, say, between 4pm and 5pm, do something messy like:
TIME(FLOOR(tim)) >= 1600
AND
TIME(CEIL(tim)) < 1700
(Caveat: there are probably multiple mistakes in my suggestion, but I hope you get the idea.)