Re: Date storage format

2005-10-25 Thread Gleb Paharenko
Hello. For example, the size of the field. DATETIME uses only 8 bytes. See: http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html Sinang, Danny wrote: >Hello, > >Can anyone tell me what advantages there are in keeping dates and times >in a MySQL >DateTime field, as oppo

Re: Date storage format

2005-10-24 Thread Martijn Tonies
> >Can anyone tell me what advantages there are in keeping dates and times in a MySQL DateTime field, as opposed to storing its >string equivalent in a Varchar field ? Decent sorting, validity checking, being able to use the DATE and TIME functions etc etc... With regards, Martijn Tonies Databa

Date storage format

2005-10-24 Thread Sinang, Danny
Hello, Can anyone tell me what advantages there are in keeping dates and times in a MySQL DateTime field, as opposed to storing its string equivalent in a Varchar field ? Regards, Danny