Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Stephen
I am not sure about cast() but convert() has a parameter to define how to format the date.
>I am updating a SQL server table and one of the fields I am updating is a character field which is a combination of a persons First name, middle initial, Last name, & Dob In the code, my syntax is
>field={firstname}+{middlename}+{lastname}+cast(dob as varchar(12))
>which works fine but after I look at the field the date is stored as
>January 13th 1987 instead on 1/13/1987, are there any functions or commands
>that will help me get the date stored into this field in the desired fashion ?
>
>Thanks For Your Help !
>Stephen J. Hunt
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement