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:
Underlying data type datetime is converted to nvarchar(20) for the column Birthday using the Japanese Style (111).
Here is the style for USA:
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:
Post a Comment