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

Mangesh G9y ago

Hello sir ,

Please change the datatype of the column to datetime an try

+1

Nirav Daraniya9y ago

Hello,
Try this

SELECT FORMAT(convert(datetime,coldate),'MMM/dd/MM') AS PerDate

+1

Purushottam Kumar9y ago

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

+1

Nirav Daraniya9y ago

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

+2

Daniel Jones9y ago

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

+1

Khaja Moizuddin9y ago

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

0

Mangesh G9y ago

select CAST(GETDATE() AS CHAR(3))+'/'+DateName(DAY, GETDATE())+'/'+Cast(Right(Year(getDate()),2)as varchar)

Mark as approved if it helps

0