Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Migrating date fields to datetime
Hello,
I am upsizing an FPDOS 2.6 app to SQL server and wish to keep code intact as much as possible. To this end I am using remote views with good results, but have found a problem with dates because SS does not have pure date fields, so I am using use datetime fields instead.
Unfortunately, this means that date arithmetic code needs to be changed by adding calls to conversion functions such as DTOT(), TTOD(), or perhaps CTOD(). However, I wish to avoid having to change code by hand as much as possible. Is there a way to handle this globally?
Normally I use date arithmetic to calculate the difference between two dates, giving a result in days, or adding a number of days days to a date.
TIA,
Alex
Suivant
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