General information
Category:
Coding, syntax & commands
>>Hi,
>>
>>My VFP 9 app has tons of windows and reports. The backend of the app is SQL Server. If I wanted to change all dates (which are currently in the American format) to European format, what do you suggest (the most effective way)? And do I need to change anything in the SQL Server for that too?
>
>The dates are stored in an internal format in both dbf and SQL tables; it's all a matter of display only. In VFP it's Set Date; in SSMS and other clients it's your locale settings (that you set in your W's control panel). The only thing to worry about, SQL side, is when you're using the convert() function to convert a datetime (or other datelike field) into string - the third parameter is numeric and you need to see which value suits the locale. That part is not automatic at all, so check for all the places where you use this function.
>
>And, BTW, there's no european date. There's the british date dd/mm/yyyy, there's german date dd.mm.yyyy, there's hungarian date yyyy-mm-dd and the old format that we used (until computers) here doesn't even have a notation, it was dd-RR-yyyy, where RR stands for date written as a roman numeral. Today is 14-XI-2018.
We use dd/mm/yyyy, dd-mm-yyyy, dd.mm.yyyy, I'm sure one of these is turkish format but no-one knows and cares that. :))
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only