InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 15:32:56 GMT20http://www.sqlservercentral.com/Forums/Topic1358433-391-1.aspx[quote][b]Skanda (9/13/2012)[/b][hr]Hi,am using below statement in a select statement," e.expiration_date" is a date fromat column, i want the date should be displayed in 13 Sep, 2012 fromat.[b]case when ( rtrim(e.expiration_date)is null OR RTRIM (e.expiration_date) = '') then '' else ' (Expires ' + rtrim(e.talent_expiration_date) + ')' end +[/b]Please help[/quote]I'm lost. Are you saying that the column e.expiration_date is defined as a date data type?Now for the standard comment, you really should do your formatting of dates in the UI (User interface, application, report, etc), not in the SQL query.Thu, 13 Sep 2012 07:54:59 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1358433-391-1.aspxSee CAST AND CONVERT [url]http://msdn.microsoft.com/en-us/library/ms187928(v=sql.105).aspx[/url]There are loads of date formats available, though you may have to truncate the time portion.You need something likeSELECT CONVERT(e.expiration_date, varchar(11), 130) AS Expiration_Date;Thu, 13 Sep 2012 04:51:24 GMTt.brown 89142http://www.sqlservercentral.com/Forums/Topic1358433-391-1.aspxHi,am using below statement in a select statement," e.expiration_date" is a date fromat column, i want the date should be displayed in 13 Sep, 2012 fromat.[b]case when ( rtrim(e.expiration_date)is null OR RTRIM (e.expiration_date) = '') then '' else ' (Expires ' + rtrim(e.talent_expiration_date) + ')' end +[/b]Please helpThu, 13 Sep 2012 03:39:28 GMTMinnu