Tuesday, May 29, 2018

How do I format date data to remove the time data portion from it?

I have date coming from database as shown with time information really does not mean anything.


How do I clean up this column so that only date is shown.

Your original SELECT query is giving you this response.



You can use the Convert() function as shown here:

The syntax for Convert() function is as shown:

CONVERT(data_type(length), expression, style)

Underlying data type  datetime is converted to nvarchar(20) for the column Birthday using the Japanese Style (111).

Here is the style for USA:


No comments: