Hi, I'm a C# developer and happy user of a SQLite database. I use System.Data.SQLite dll and I'm saving datetime data asSystem. DateTime.Ticks and I'm very happy with it. The only thing I would like to have is something similar to the existing SELECT datetime(1092941466, 'unixepoch');
I would need something like: SELECT TicksToDateTime(AppointmentStart) where AppointmentStart is an ipothetical Table Column defined as integer in SQLITE (System.Int64 in .Net). This way I could build a view to look my appointment table in a human readable format. Is there such a function or is there a way to build it? Best Regards Roberto Dalmonte _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users