Hi, i'd like to alter a table which have a date and time field so 3 Bytes for date and 3 Bytes for time. I'd table to add a new field to store date like this : YYYYMMDDHHMMSS.
In fact, I can't use indexes on sql query like select with order by with 2 fields date + time and with one unique field i can. So, for this new field that i'll insert and update manually, should i use a Bigint which required 8 Bytes or a Timestamp(14) with 4 Bytes ? Timestamp looks great but, can i insert and update it manually ?? Thanks David --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php