# [EMAIL PROTECTED] / 2003-03-31 07:38:44 -0500:
> Uttam wrote:
>
> >u can use highly customizabe MySQL DATE_FORMAT() function for retrieving
> >date in desired format.
> >
> Thanks for the detailed information.
>
> >For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date)
> >function to return unix timestamp of the date and use the php date
> >functions
> >like date(), getdate() etc. on it.
>
> This is probably the technique I'll use.
or better yet, *store* unix timestamps in the database. then you
won't have to convert them on every retrieval.
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message. see http://www.eyrie.org./~eagle/faqs/questions.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
