Navigation:  Interfacing QDV > Date Conversion

For QDV7 use, the dates from SQL databases are stored as float numbers, but in a different date format than in SQLite (file) databases.

To convert these numbers to dates outside of QDV7, use:

select Reference,

convert(datetime, AlterDate) as AlterDate, convert(datetime, ArticleDate) as ArticleDate

from Articles

 

To correct invalid number (date), update them using the Articles Converter or use the following SQL statement:

update Articles set

ArticleDate = convert(float, convert(datetime, '2013-01-01T00:00:00')),

AlterDate = convert(float, convert(datetime, '2013-11-01T00:00:00'))

 

or to current date time:

update Articles set

ArticleDate = convert(float, getdate()),

AlterDate = convert(float, getdate())