Information générale
Catégorie:
Codage, syntaxe et commandes
Garrett,
Yeah, Ed mention the Y2K problem which I didn't realised it b4. Thanks for the info.
:)
Gan
>>I guess your tip will help. I'll put an extra field in my cursor as,
>>
>>SELECT substr(month,5,2)+substr(year,4,2) AS mysort FROM.... ORDER BY mysort
>>
>>since it can kill 2 birds with one stone, as how Ed stated.
>
>If you're going to put an extra field in, why don't you use the full date? That way, you don't have any Y2K issues on the sorting.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement