Thanks Danny
I'm using mySQL and in this case the format you suggested didn't work but
it put me on the right path to find the answer.
Where does one find a reference to all the format arguments?
Peter
-----Original Message-----
From: "Danny Mallory" <[EMAIL PROTECTED]>
To: "sambar List Member" <[EMAIL PROTECTED]>
Date: Tue, 21 Jan 2003 21:12:55 -0600
Subject: [sambar] Off topic SQL sambar scripting {02}
> 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/
>
>
-------------------------------------------------------
To unsubscribe please go to http://www.sambar.ch/list/
