>All Experts,
>
>From visual foxpro i m trying to retrive date from sql server using Convert( char(11), date) function ,
>but it return as 'Apr 12 2005', i need in '12/04/2005' charecter format. How to do that.
>
>Regards
>Abdulla
SELECT CONVERT(char(10), DateTimeField, 101)
Check SQL Books Online for CONVERT() help, espetialy the 3th parameter
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.