Re: [PHP] Re: I think this is a mysql question

2004-02-12 Thread Marek Kilimajer
Ronald Ramos wrote: create table oras( NameVARCHAR(30), TimeIn DATETIME, TimeOut DATETIME, Total DATETIME ); insert into oras values('Nhadie','2004-10-10 10:10:00','2004-11-11 12:12:00','TIMEDIFF(TimeIn,TImeOut)'); Hi, Are those correct? Because the value on the Total field is 000-00-00 00:

Re: [PHP] Re: I think this is a mysql question

2004-02-12 Thread Marek Kilimajer
Ronald Ramos wrote: create table oras( NameVARCHAR(30), TimeIn DATETIME, TimeOut DATETIME, Total DATETIME ); insert into oras values('Nhadie','2004-10-10 10:10:00','2004-11-11 12:12:00','TIMEDIFF(TimeIn,TImeOut)'); Hi, Are those correct? Because the value on the Total field is 000-00-00 00:

RE: [PHP] Re: I think this is a mysql question

2004-02-11 Thread Ronald Ramos
TECTED] Sent: Thursday, February 12, 2004 9:08 AM To: [EMAIL PROTECTED] Subject: [PHP] Re: I think this is a mysql question Ronald Ramos wrote: > How can I use PHP to compute the difference between two dates(with > time)? Let's say in mysql, I have field 1, login, and on field 2, I &

[PHP] Re: I think this is a mysql question

2004-02-11 Thread Justin Patrin
Ronald Ramos wrote: How can I use PHP to compute the difference between two dates(with time)? Let's say in mysql, I have field 1, login, and on field 2, I have logout. How can I compute the diffrence between login and logut and output it on field 3 let's say totaltime. Is this a mysql question? Or