SQLite datetime conversion question.

-- see it helps

select convert(varchar, [datetime], 110) as oDate from talMonitor

or

select cast([datetime] as datetime) from yourtable

http://www.karaszi.com/SQLServer/info_datetime.asp

"select cast([datetime] as datetime) from yourtable"  does not change the output.

EDIT

The field name is datetime, the data type is real

try this helps

http://www.mssqltips.com/tip.asp?tip=1145

How do you know the date represents '2011-05-06' by the way? i.e., how was this decimal value generated in the first place. When I try this in SQLite, I get '-4601-05-06' with emphasis on fact that it is a negative year. May be some sort of Julian day conversion. If this is a simple numeric representation of date anchored at '1900-01-01' in float format as is the case in MS SQL Server, the result of CAST(...) is '2011-06-13 09:19:15.840'. If you can answer the question of where the value originates, it may help determine how to programmatically convert it back.

The information comes from a BDF file that I am querying.  I only have access to the BDF file.  5-06-2011 is when I believe that datetime field started getting populated.  it should be a simple process to display the info in standard date time format.  

It should be simple, but each database system stores dates in its own fashion, though most are numerical in nature. For example, some are the number of seconds from 1970-01-01. Others are number of days as a floating point from 1900-01-01. The trick is finding the reference point. The difficulty you are having is that it appears SQLite is storing the values in Julian days, so your number is registering as some date in B.C. To adjust to proper time, once you know the reference you can just add the value you have to that. I can show you how, but again you will need to know the reference point. When I tried with 1900-01-01, I got June 13 and not May 6.