select DATE_FORMAT(datetime, \'%Y-%m-%d %T\') from some_table or
http://www.mysql.com/doc/en/DATETIME.html Danny On 22/Jan/2003 15:30:59, Peter wrote: > 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 <A TARGET="_blank" >HREF="http://www.sambar.ch/list/";>http://www.sambar.ch/list/</A> > > > > > ------------------------------------------------------- > 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/
