On 1/29/09, venkat karri <venkat9...@gmail.com> wrote: > Hi All, > > 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.
http://www.sqlite.org/lang_datefunc.html You might do well by spending some time on the sqlite.org website. It will make your experience with sqlite more pleasant and efficient. > > Regards, > > Venkata > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users