Date format

[ashab02]

Hello

Having trouble exporting some data into the format I want.

I have a datetime column and need to change that so it appears in the following format dd/mm/yyyy. I have tried converting it to a type of 103 but for some reason when I view my exported text document it has the date stamp as well. An example is '1966-05-13 00:00:00.000'

Can someone show me how to get it into the correct format?

Shab

 

[SQLBI]

Hi,

Have you tried using CONVERT(char(10), YourDate, 103)?


Cheers,
Leigh

"If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem

 

[ashab02]

thats perfect, thanks for your help