Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Converting DateTime from one culture to another
Message
 
 
À
14/04/2005 16:54:31
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Divers
Thread ID:
01004901
Message ID:
01005176
Vues:
20
Andrew,

Is the column a datetime datatype? If it is then the output of the column can look like whatever localized format you want.
select getdate(), convert( varchar, getdate(), 102 ), convert( varchar, getdate(), 101 )
>Does anyone have an example of how to convert a DateTime from an arbitrary culture to another culture (for example en-US).
>
>Our dates are stored in SQLServer in en-US format but our users will most likely be using no-NO culture. This is causing me grief because I need to convert the date to en-US in order to use it as a parameter for my SQL.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform