SQLTeam.com | Weblogs | Forums

Date format


#1

Hello
I have a datetime value

I want to extract the data without seconds

example

Mydate = '2015-05-02 12: 40: 19,000'

I want to read only

Mydate = '2015-05-02 12:40'
What is the format
Thank you


#2

Please remove duplicate post.