Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
select date format 1
- Thread starter brownfox
- Start date
-
1
- #2
SELECT DATE_FORMAT(this_date, '%Y-%m-%d') FROM table
sleipnir214
Programmer
Sure. It will involve invocation of MySQL's date_format() builtin function.
Something along the lines of:
SELECT date_format(DOB, '%Y-%m-%d') from DB....
Check the documentation on date_format(). My format string may or may not be right.
Want the best answers? Ask the best questions!
TANSTAAFL!!
Something along the lines of:
SELECT date_format(DOB, '%Y-%m-%d') from DB....
Check the documentation on date_format(). My format string may or may not be right.
Want the best answers? Ask the best questions!
TANSTAAFL!!
- Thread starter
- #4
- Status
Similar threads