On Wed, 22 Sep 2004 00:20:32 +0530, Eldo Skaria <[EMAIL PROTECTED]> wrote: > That seems to be vague to me. > I would like to know how the time is converted to numbers? is it upto > seconds or even beyond that? > happier if resolved, >
It is converted in such a way that looking at number we can easily read the date mysql> select now(), now() + 0; +---------------------+----------------+ | now() | now() + 0 | +---------------------+----------------+ | 2004-09-21 22:29:30 | 20040921222930 | +---------------------+----------------+ Please read the manual. 6.3.4 Date and Time Functions -- With best regards, Gleb Kozyrev. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]