How do I display the following in a 'readable' datetime format?

[elmeryak]

\[code\]Database : SQLite Column : SomeTable.Logged (DateTime) \[/code\]Im using the \[code\]System.Data.SQLite\[/code\] component. I save a datetime value in the \[code\]Logged\[/code\] column as ticks. e.g. using c#\[code\]DateTime.Now.Ticks;\[/code\]An example value that is saved in \[code\]SomeTable.Logged\[/code\] is: \[code\]634399267463299880 \[/code\]How, using sql, would I display this in a 'normal' date? e.g. \[code\]'01-05-2011 13:45:22'\[/code\]?I'm aware of the page http://www.sqlite.org/lang_datefunc.html , but I can't quite get things to work the way I want.