"venkat karri" <venkat9...@gmail.com>
wrote in message
news:265032e50901291849h68ff004ay642ba7357a701...@mail.gmail.com
> 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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to