Hi

I have a .txt file that is loaded into my table. This is done
using LOAD DATA INFILE....
One of the columns data is a unix timestamp from the .txt file.
The column is called begin.

I have created the column as a varchar before
and then converted the date using FROM_UNIXTIME(), so it can be readable.

My question is:
Should I create this column "begin" as "DATETIME, DATE, or TIMESTAMP" or
since I'm converting the unix time leave it as a varchar???

Thanks,
Ron



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to