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
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:00:00. I think ther