----- Original Message -----
From: "Mike Podlesny" <[EMAIL PROTECTED]>
To: "Scott Gerhardt" <[EMAIL PROTECTED]>
Sent: Tuesday, January 16, 2001 3:20 PM
Subject: Re: SQL HELP
> Thanks for your help but that unfortunately doesn't answer the question,
> unless I am looking at it wrong. I want the sql statement to read
something
> to the affect:
>
> SELECT * FROM Table
>
> * is about 40 fields, which I do not want to type all of them out
>
> so do i do the following?
>
> SELECT DATE_FORMAT(*,'%M %D %Y')
>
>
> ----- Original Message -----
> From: "Scott Gerhardt" <[EMAIL PROTECTED]>
> To: "Mike Podlesny" <[EMAIL PROTECTED]>
> Sent: Tuesday, January 16, 2001 3:17 PM
> Subject: RE: SQL HELP
>
>
> > SELECT fields, DATE_FORMAT(datefield, '%M %d, %Y');
> >
> > I just looked it up myself...It's all in the manual at:
> > http://www.mysql.com/doc/D/a/Date_and_time_functions.html
> >
> > - Scott
> >
> >
> > > -----Original Message-----
> > > From: Mike Podlesny [mailto:[EMAIL PROTECTED]]
> > > Sent: January 16, 2001 12:55 PM
> > > To: mySQL Mailing List
> > > Subject: SQL HELP
> > >
> > >
> > > I want to select all the fields in from the mySQL database except
> > > I want my
> > > date field to be returned in the format of:
> > >
> > > January 16, 2001
> > >
> > > How can this be done without having to do the select in this manner:
> > >
> > > SELECT field1,field2,MONTHNAME(datefield),DAYOFMONTH(datefield),
> > > YEAR(datefield),field3,field4...etc. FROM table
> > >
> > > Thanks for your help
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> > >
> > >
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
