Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Time () function. How to convert to 13:00 to 1:00
Message
De
27/10/2005 08:46:55
 
 
À
27/10/2005 08:41:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01062587
Message ID:
01062591
Vues:
13
>Hello all!
>
>I use the time function as a clock, but when its after 12:00, the timer instead of using 1:00 pm 2:00 pm 3:00 pm , it uses 13:00 , 14:00 and 15:00, is there any way to convert them to a regular time value?
>
>Thanks in advance...
>
>Juan :)

From Help:

TIME( ) always returns a value in 24-hour format and isn't affected by SET HOURS. The value returned by DATETIME( ) is determined by the current SET HOURS setting.
SET HOURS TO 12
SET DATE AMERICAN
? RIGHT(TTOC(DATETIME()),11)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform