On 8 Aug 2003 at 10:16, Oswaldo Castro wrote:
> I have two datetime fields on my database. I nedd to return the
> difference in minutes between them. I tried date_sub,
> extract(hour_minute from ...) and it does't work
SELECT ( UNIX_TIMESTAMP(datetime2) - UNIX_TIMESTAMP(datetime1) ) /
60;
(assu
On 29 Nov 2001, [EMAIL PROTECTED] wrote:
> I need to calculate the difference in seconds for two registers type
> datetime, My question is if exists some function or trick on mysql for
> perform it? I need this for calculate some information about time for
> a billing system so I need precision of
