Apr 21, 2004 #1 lhugh MIS May 21, 2000 115 CA which function can I use to select the date in order to return date in this format YYYY-MMM-DD Thanks
which function can I use to select the date in order to return date in this format YYYY-MMM-DD Thanks
Apr 21, 2004 #2 sleipnir214 Programmer May 6, 2002 15,350 US The query: select date_format(now(),'%Y-%b-%d'); returns: 2004-Apr-21 Want the best answers? Ask the best questions! TANSTAAFL!! Upvote 0 Downvote
The query: select date_format(now(),'%Y-%b-%d'); returns: 2004-Apr-21 Want the best answers? Ask the best questions! TANSTAAFL!!