Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting DateTime from one culture to another
Message
 
 
To
14/04/2005 16:54:31
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
01004901
Message ID:
01005176
Views:
19
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform