Re: Report(query)

2005-05-12 Thread Harald Fuchs
In article [EMAIL PROTECTED], Seena Blace [EMAIL PROTECTED] writes: Hi, I want report like this date process pending wip 5/10/051030 40 5/11/05 09 28 60

Re: Report(query)

2005-05-12 Thread Seena Blace
ROLLUP is not working with current version.IS any way i can do? I have 1 column names time with data type datetime.I want to get report like -mm-dd format. Can I get by using date_format(nameofcolumn,'%Y-%m-%d')? Harald Fuchs [EMAIL PROTECTED] wrote: In article [EMAIL PROTECTED], Seena

Re: Report(query)

2005-05-12 Thread Eamon Daly
@lists.mysql.com Sent: Thursday, May 12, 2005 12:54 PM Subject: Re: Report(query) ROLLUP is not working with current version.IS any way i can do? I have 1 column names time with data type datetime.I want to get report like -mm-dd format. Can I get by using date_format(nameofcolumn,'%Y-%m-%d

Report(query)

2005-05-11 Thread Seena Blace
Hi, I want report like this Table description is like as follows Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id |

Report query problem

2004-07-04 Thread wally . randall
Coming from an Oracle background I am struggling with the following report generation. This is a report which needs to be created using mySQL: Week of mm/dd/yy mm/dd/yy mm/dd/yy mm/dd/yy mm/dd/yy Total All Groups nn nn nn nn