How to display current date as given format in SQL SERVER ?

Question

How to display current date in given format. Display current date as Dec/28/12 in SQL Server. Thanks P urushottam

Nirav Daraniya · Answer

Hello Purushottam Simple for getting any datetime format you can use FORMAT function in SQL. Example: SELECT FORMAT(getdate()'MMM/dd/MM') AS PerDate. Output: Dec/29/12

Mangesh Gaherwar · Answer

Hello sir  Please change the datatype of the column to datetime an try

Nirav Daraniya · Answer

Hello Try this SELECT FORMAT(convert(datetimecoldate)'MMM/dd/MM') AS PerDate

Purushottam Kumar · Answer

Thanks to all for your reply But i have some issue. i want to display date from column which is user define type see below column name datatype ------------------ ------------ coldate UserCharFldType:nvarchar(20) Now tell me how to display date in above mention format . Thanks Purushottam

Daniel Jones · Answer

take a look at these links: https://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/ http://www.sqlinfo.net/sqlserver/sql_server_SELECT-Formatting_Date_Time.php

Khaja Moizuddin · Answer

http://www.sql-server-helper.com/sql-server-2008/sql-server-2008-date-format.aspx Here you will get all format which you are looking for

Mangesh Gaherwar · Answer

select CAST(GETDATE() AS CHAR(3))+'/'+DateName(DAY GETDATE())+'/'+Cast(Right(Year(getDate())2)as varchar) Mark as approved if it helps