Date format in sql

[imnotso]

I've a varchar variable in my stored procedure returning either a date or a piece of text depending on the condtional code. Both return fine but the date comes back as '6 DEC 2007 08:04am' because of the varchar. How do I get it to return in the format 'dd/mm/yyy hh:mm:ss' ? I've tried cast as, convert and the date formatting, it always returns as described. Should I format it in my c# code behind, it that eaiser? Thanks in advance. Harvey

[SimulationofSai]

When you convert date to varchar, you can specify styles which will tell how to format the output of the convert function.

imnotso# wrote:

How do I get it to return in the format 'dd/mm/yyy hh:mm:ss' ?

You can try CONVERT(varchar, Getdate(), 131)

SG Cause is effect concealed. Effect is cause revealed.

[imnotso]

Thanks for the quick response, I have tried that but it converts it to a strange date. not the date entered. I have done it in the code behind in c#. Thanks though. Harvey