Well, to do date calculations, use DATE_SUB() and DATE_ADD() functions.
To convert to some other functions, use DATE_FORMAT() function. For
templates that DATE_FORMAT() needs, please refer to documentation.
There're bunch of'em
--
sherzodR
On Mon, 26 Nov 2001, Thomas Spahni wrote:
>On Mon, 26 Nov 2001, Julio Faerman wrote:
>
>> Is there anything like a "to_hours()" function ?
>> I need my query to to calculate how much time there is between two time
>> values....
>
>Julio,
>
>have a look at the UNIX_TIMESTAMP(date) and FROM_UNIXTIME(unix_timestamp)
>functions. These allow to convert a date to seconds. Then you do your
>maths, calculate a difference and convert back to any format you like.
>
>Thomas
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php