MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:September 5 1999 10:45am
Subject:Re: escaping characters in date format?
View as plain text  
Jesse writes:
 > Although there doesn't seem to be any documented (for 3.21.29-gamma for Win32)
 > escapes for the date_format function format string, would there be a way to
 > easily include, say, "at" in the format without having the 'a' changed into
 > its corresponding format value?  "\" doesn't seem to work... seems like
 > this should be a feature for DATE_FORMAT().
 > 
 > Thanks,
 > 
 > Jesse
 > 
 > 
 > 

Hi!

Why would you use DATE_FORMAT to insert any string. 

You can use any of string functions to INSERT or what ever in the
output of DATE_FORMAT, because DATE_FORMAT outputs a string which
itself can be changed in a query.

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped|
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+
Thread
escaping characters in date format?Jesse5 Sep
  • Re: escaping characters in date format?sinisa5 Sep
    • Re: escaping characters in date format?Jesse6 Sep
      • Re: escaping characters in date format?Martin Ramsch6 Sep
  • Re: escaping characters in date format?Martin Ramsch5 Sep