Get date format as 19 Mar 2015 15:32

Jak

Member

858 Points

132 Posts

Hi,

Get date format as 19 Mar 2015 15:32

Views: 8506
Total Answered: 1
Total Marked As Answer: 0
Posted On: 18-Mar-2015 14:38

Share:

Answers

Rahul M...

Teacher

4822 Points

23 Posts

Hi,

I have uses following query and working fine.

SELECT CONVERT(VARCHAR,GETDATE(),106) +' '+ CONVERT(VARCHAR,DATEPART(HH,GETDATE()))+':'+ CONVERT(VARCHAR,DATEPART(minute,GETDATE()))

Posted On: 18-Mar-2015 14:39

Discussion

MVC Design pattern