Have you tried using a format command in your sql string? Not sure on your database flavor but is very common to format the date as needed during the select.
ie; select FORMAT([date],'mm/dd/yyyy') as Dateformatted Danny On 22/Jan/2003 02:09:42, Peter wrote: > I'm having a real problem with retrieving the results I want with sambar > scripting. I have been through 3 turotials and none have been any help so > I'm hoping someone here has an idea for me. > > In a nutshell I'm grouping byte counts on a daily basis from a table. The > querry below does what it should but the date format comes out 20030121 > not a pretty 2003/01/21 if I remove the left() I get the full date time > which I don't want either. > > <RCQmylog sql="select left(tstamp,10),sum(bytes) from RC$tbl group by left > (tstamp,10);"> > <RCwhile RCFmylog = 1> > <b>Traffic on:</b> <RCDmylog.1> - <i><RCDmylog.2></i> bytes<br> > <RCendwhile > > Regards > Peter > ------------------------------------------------------- > To unsubscribe please go to <A TARGET="_blank" >HREF="http://www.sambar.ch/list/";>http://www.sambar.ch/list/</a> > > > ------------------------------------------------------- To unsubscribe please go to http://www.sambar.ch/list/
