Bonjour,
I'm creating a tasks management DB in SqLite.
It should be used from ODBC clients as ell as from native SqLite GUIs
(SqLitePlus, DbManager, custom Python apps).
I looked for info on the web regarding the best choice for storing dates and
time.
Choice is not evident.
Should I use SQL_DATE or DATE for type ?
DataEntry via native SqLite GUIs gives strings correctly interpreted in
SqLite world, but not in ODBC (Access 2000).
DataEntry via ODBC Access 2000 gives strings correctly interpreted in SqLite
world.
I guess that entering OdbcDateStrings like {ts '2001-10-10 12:58:00'} or
{'2001-10-10 12:58:00'} via native SqLite GUIs would gives strings
correctly interpreted by Odbc driver , but these strings are not comfortable
to enter in aSQLITE adm GUI like SqLitePlus or DbManager.
Do you have best practices or infos about that ?
Is the Roadmap of SqLite so thzat datetime functions would be soon
integrated ?
Thanks on forward
___________________________________________________
P-Y Delens, Manager
LIENTERFACES - PY Delens, sprl
Avenue Dolez, 243 - 1180 Bruxelles
phone : 32 2 375 55 62
fax : 32 2 374 75 74
mail : [EMAIL PROTECTED]
web : www.lienterfaces.be
___________________________________________________
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
