How to convert Date to character in SQL server

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to convert Date to character in SQL server

Message

12/04/2005 02:12:27

Abdulla Abdul Rahiman
Alits Information Technology
Dubai, Émirats Arabes Unis

Tous

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

How to convert Date to character in SQL server

Versions des environnements

Visual FoxPro:

VFP 8 SP1

OS:

Windows 2000 SP4

Network:

Windows 2000 Server

Database:

MS SQL Server

Divers

Thread ID:

01003594

Message ID:

01003594

Vues:

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

Répondre

Fil

Voir

Click here to load this message in the networking platform