Remove time from datetime

Question

0.00/5 (No votes)

See more:

Hi all

I have date in my database with datetime.

02-02-2015 20:15:49

I want to remove the time part from all the records.

Please tell me the way to do that.

Posted 3-Mar-15 0:01am

Black_Rose

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rajat_RJT · Answer 1 · 2015-03-03T00:07:00

Solution 1

Try this-

SELECT convert(varchar, columnName, 105)

Posted 3-Mar-15 0:07am

Rajat_RJT

Remove time from datetime

1 solution

Solution 1

Add your solution here

Preview 0

Remove time from datetime

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us