Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Select with Character and Time
Message
De
05/01/1999 15:11:37
 
 
À
05/01/1999 14:55:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00172892
Message ID:
00172900
Vues:
27
Hi Ed, Andersen:

SELECT * FROM table WHERE CTOT(hour) > CTOT(TIME())

This does it.


>>
>>I have a table that have a field Called HOUR and him data type is caracter.
>>
>>and i have to do a Select Sql wherer Hour > Time()
>>
>>how can i do this?
>>
>>thanks
>
>Something like this:
>nHour=HOUR(datetime())
>Select * From MyTable Where MyTable.Hour>nHour
>
>I guess you will also want to filter by date here, because without it the result does not make much sense.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform