MySQL: should I use "date" and "time" fields when I already have a timestamp field?

Posted by KeyStroke on Stack Overflow See other posts from Stack Overflow or by KeyStroke
Published on 2010-04-13T15:02:38Z Indexed on 2010/04/13 15:12 UTC
Read the original article Hit count: 273

Filed under:
|
|
|

Hi,

I have a MySQL table where there is a 'date_added' (date) field, 'time_added' (time) field and 'timestamp' (int) field.

I found out afterwards that I can convert timestamp to a date or a time anyway, so so does that mean I could get rid of the other date/time fields and keep the timestamp only?

Thanks in advance

© Stack Overflow or respective owner

Related posts about mysql

Related posts about date