"venkat karri" <[email protected]> wrote in message news:[email protected] > I have a database where date is stored in the integer format ( eg: > 1125426109) I want the output in mm/dd/yyyy format. can any one tell > me the syntax to convert the date.
select strftime('%m/%d/%Y', 1125426109, 'unixepoch');
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
