Check in the manual about the DATE_FORMAT function
HTH
Quentin
-----Original Message-----
From: Mike Podlesny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 17 January 2001 07:55
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
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
---------------------------------------------------------------------
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
