SELECT DATE_FORMAT("2010-08-30 21:19:58", "%a. %b %e, '%y"); : Date Format « Date Time « SQL / MySQL

Home
SQL / MySQL
1.Aggregate Functions
2.Backup Load
3.Command MySQL
4.Cursor
5.Data Type
6.Database
7.Date Time
8.Engine
9.Event
10.Flow Control
11.FullText Search
12.Function
13.Geometric
14.I18N
15.Insert Delete Update
16.Join
17.Key
18.Math
19.Procedure Function
20.Regular Expression
21.Select Clause
22.String
23.Table Index
24.Transaction
25.Trigger
26.User Permission
27.View
28.Where Clause
29.XML
SQL / MySQL » Date Time » Date Format 
SELECT DATE_FORMAT("2010-08-30 21:19:58", "%a. %b %e, '%y");
    
mysql>
mysql> SELECT DATE_FORMAT("2010-08-30 21:19:58""%a. %b %e, '%y");
+------------------------------------------------------+
| DATE_FORMAT("2010-08-30 21:19:58""%a. %b %e, '%y"|
+------------------------------------------------------+
| Mon. Aug 30'10                                     |
+------------------------------------------------------+
row in set (0.00 sec)

   
    
    
    
  
Related examples in the same category
1.Format a date 1
2.Format a date 2
3.Format a date 3
4.Format a date 4
5.Format a date 5
6.Date Symbols in DATE_FORMAT, TIME_FORMAT, and FROM_UNIXTIME
7.Time Symbols in DATE_FORMAT, TIME_FORMAT, and FROM_UNIXTIME
8.Common used flags for DATE_FORMAT()
9.DATE_FORMAT Specifiers
10.DATE_FORMAT function
11.SELECT DATE_FORMAT('2005-12-31', '%M %d %Y')
12.SELECT DATE_FORMAT('2005-12-31', '%D of %M')
13.To return the birthdays of all staff in the format MM/DD/YYYY, use the DATE_FORMAT() function
14.SELECT DATE_FORMAT("2010-08-30 21:19:58", "%W %M %d %Y");
15.SELECT DATE_FORMAT("2010-08-30 21:19:58", "%m-%e-%Y %l:%i%p");
16.SELECT DATE_FORMAT("2010-08-30 21:19:58", "%m-%e-%Y %h:%i%s%p %W");
17.SELECT DATE_FORMAT("2010-08-30 21:19:58", "%M %D,%Y %k:%i CST %W");
18.Formatting Dates and Times
19.SELECT @@GLOBAL.DATETIME_FORMAT
20.SET @@SESSION.DATETIME_FORMAT = DEFAULT
21.Decomposing Dates and Times Using Formatting Functions
22.Telling MySQL How to Display Dates or Times
23.The DATE and TIME data types use the following format:
24.Present a date differently than in CCYY-MM-DD format or present a time without the seconds part
25.Calculating One Date from Another by Substring Replacement
26.The string replacement technique can be used to produce dates with a specific position within the calendar year
27.For Christmas, replace the month and day with 12 and 25:
28.%a is the abbreviated weekday name, %D is the day of month with the suffix attached, %b is the abbreviated mon
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.