List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:October 25 2005 8:12am
Subject:Re: Date storage format
View as plain text  
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 opposed to storing its string equivalent in a
>Varchar field ?

>Regards,
>Danny


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
Date storage formatDanny Sinang25 Oct
  • Re: Date storage formatMartijn Tonies25 Oct
  • Re: Date storage formatGleb Paharenko25 Oct