Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Time display
Message
De
22/05/2013 16:01:02
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01574527
Message ID:
01574538
Vues:
44
>>>Hi everybody,
>>>
>>>I am wondering how can I display datetime value using
>>>
>>>mm/dd/yyyy hh:mm:ss format where hours are in 24 format? Using transform(datetime()) returns date with AM/PM settings. Also, I may want to display it just up to hh:mm (no seconds).
>>
>>I recommend not doing that at all. I never offer that to clients due to the ambiguity of not knowing whether they're looking at mm/dd or dd/mm.
>>
>>Instead I give them something like 22-May, 22May, May-22 or May22. Three letters for the month is always distinct i.e. Mar/May, Jun/Jul etc. I think there are standard 2 letter month abbreviations if you're so inclined.
>
>We actually have preferences defined for the date, so if they want mm/dd/yyyy, this is what we will provide.

Well, you could offer new preferences :) I bet if you offer them any of those new preferences they would choose them instead.

Ambiguity costs money - that's why STRICTDATE was invented. If after looking at better options they still absolutely, positively want mm/dd then of course you give them that. But you look good offering them better options, and pointing out why mm/dd is suboptimal.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform