Thanks dude, that works !!!!!!!!!!!!!
On 1/29/09, Igor Tandetnik <[email protected]> wrote: > > "venkat karri" <[email protected]> > wrote in message > news:[email protected]<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 > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
